CONCAT
CONCAT(string, string [,...])
Parameters
string
Description
Combine strings. Unlike with the operator ||, NULL parameters are ignored and do not cause the result to become NULL. This method returns a string.
Example
SELECT CONCAT(NAME, '!') FROM Players;
Updated about 5 years ago