/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 vote250 views1 answer
How to fetch data from database in sql
SQL
4 votes205 views1 answer
Wilayah indonesia database
SQL
0 vote189 views6 answers
Unique key in sql
SQL
1 vote232 views1 answer
Mysql search like order by best match
SQL
0 vote196 views1 answer
Call procedure in wordpress
SQL
1 vote196 views1 answer
Oracle sql assign unique number to each grouping
SQL
3 votes227 views3 answers
Sql current year
SQL
7 votes220 views1 answer
Set sequence value oracle
SQL
12 votes236 views6 answers
Distinct in sql server
SQL
0 vote276 views1 answer
Consulta alias con inner join
SQL

Share