CONCAT

CONCAT(string, string [,...])

Parameters

  • string - an argument.

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