Revision history [back]
 | 1 | initial version |
To add a character to a SQL string, you can use the CONCAT function. The CONCAT function is used to concatenate two or more strings into one string.
The syntax for the CONCAT function is as follows:
CONCAT(string1, string2)
For example, if you want to add the character '!' to the end of a SQL string, you can use the following code:
SELECT CONCAT('This is a SQL string', '!')
This will return the string "This is a SQL string!".
You can also add a character to the beginning of a SQL string using the CONCAT function with the following syntax:
SELECT CONCAT('!', 'This is a SQL string')
This will return the string "!This is a SQL string".