Answers for "concatenate columns sql"

SQL
4

concatenation in sql

We use "||" to concatenation in Sql

example:
WHERE LOWER(FIRST_NAME || LAST_NAME)  LIKE '%d%' ;
Posted by: Guest on January-07-2021
0

Concatenate columns in table

/*  Takes several columns to form a single name  */
select concat(prefix,' ',first,' ',last,' ',suffix) as title from names
Posted by: Guest on June-01-2021

Code answers related to "concatenate columns sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language