Joining a column with the column value + String
Joining a column with the column value + String
(OP)
Example
When i have a column comment3' from the table 'TEST'
If i run, the string value n will get added to the start
one record resides in table
comment3 current value = 'pink'
UPDATE Test
SET comment3 = CONCAT('n',comment3)#
This returns = 'npink'
However i want it the other way. For the value 'n' to be at the end of the string.
I tried reversing the order of sql
SET comment3 = CONCAT(comment3,'n')#
The query ran but the 'n' did not add.
i also tried the comment3 = comment3 + 'n' /query ran but did not add
and then comment3 = 'n' + comment3 /query ran and was successful
Please can you assist how can add the string to the end of the this fields value
Thank you
When i have a column comment3' from the table 'TEST'
If i run, the string value n will get added to the start
one record resides in table
comment3 current value = 'pink'
UPDATE Test
SET comment3 = CONCAT('n',comment3)#
This returns = 'npink'
However i want it the other way. For the value 'n' to be at the end of the string.
I tried reversing the order of sql
SET comment3 = CONCAT(comment3,'n')#
The query ran but the 'n' did not add.
i also tried the comment3 = comment3 + 'n' /query ran but did not add
and then comment3 = 'n' + comment3 /query ran and was successful
Please can you assist how can add the string to the end of the this fields value
Thank you
Talk To Other Members
RE: Joining a column with the column value + String
CODE
If you got an error, what error?
If it didn't add, what if you try:
CODE
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Joining a column with the column value + String
the rtrim did the trick. Thank you
The previous way that I was doing it did not give an error nor did it add the 'n'