Sql 2016 updating a substring in a char field dating gave up
FOR is optional, and specifies the length of the extracted substring.
Have you ever needed to change part of a string in SQL Server?
This value had to be stored in the first character of a field in a physical file in the database.
Simple Logic and we want it done quick, efficient, simple and easy to maintain for future programmers. Given this example, I had to update just the first character of a column (MAPGE) replacing that character:1 with the value stored in a field called flag Opt Out Cell Phone : // Update the first character of MAPGE on LMGEP with the new flag // value of Y/N passed in via JSON exec sql update LMGEP SET MAPGE = concat(flag Opt Out Cell Phone,substr(MAPGE ,2)) where KYDTGE = my Res Key Date and SEQGE = my Res Sequence; IBM i Software Developer, Digital Dad, AS400 Anarchist, RPG Modernizer, Alpha Nerd and Passionate Eater of Cheese and Biscuits.
For any SQL Server Performance Tuning Issue send an email at [email protected]
Pinal is also a Cross Fit Level 1 Trainer (CF-L1) and Cross Fit Level 2 Trainer (CF-L2).
Most of the time, I use the latter option and have the account names copy from the exiting accounts.