/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 vote215 views1 answer
Setval postgres example table id
SQL
0 vote302 views1 answer
Add user mysql wordpress
SQL
0 vote209 views1 answer
Oracle sql add column auto generated value
SQL
0 vote212 views1 answer
Grant owner postgresql
SQL
0 vote210 views1 answer
Postgresql in vs any performance
SQL
12 votes204 views6 answers
Between in sql
SQL
0 vote206 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote250 views1 answer
Alternative for LIMIT sql
SQL
1 vote191 views1 answer
Oracle sql listagg
SQL
1 vote202 views2 answers
Postgresql backup and restore globals and data
SQL

Share