/SQL/Concatenation in sql

Concatenation in sql

Concatenation in sql

We use "||" to concatenation in Sql

example:
WHERE LOWER(FIRST_NAME || LAST_NAME)  LIKE '%d%' ;

4

String concatenation sql server

SELECT CONCAT('Comments: ' , CAST(9 AS varchar(12))) AS Result;

0

Concat two columns in sql server

select Convert(nvarchar(50),ID)+'-'+Convert(nvarchar(50),Year) as ID_Year from tablename

-1

Source: codeproject.com

Similar codes

0 vote267 views1 answer
Sql server datetime to string
SQL
0 vote271 views1 answer
Null column as zero in mysql
SQL
0 vote326 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote255 views1 answer
Hive batch drop table
SQL
0 vote265 views1 answer
Search column name sql
SQL
0 vote273 views1 answer
Get who is hired in month in sql
SQL
4 votes256 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote262 views1 answer
How to order result of subquery in select
SQL
1 vote274 views2 answers
Pad zero sql server
SQL
0 vote247 views1 answer
Zsh: command not found: mysql mamp
SQL

Share