SQL CONCATENATE - Introduction and syntax
SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai
Explain the SQL CONCATENATE statement. Write SQL syntax for the SQL CONCATENATE
statement along with an example.
SQL CONCATENATE: This clause combine together (concatenate) the
results from several different fields.
Syntax:
CONCAT(str1, str2, str3, ...):
Example:
SELECT CONCAT(first_name, last_name) FROM employee WHERE salary >
1000
|