/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

7 votes238 views1 answer
Grant schema permissions postgres
SQL
0 vote279 views1 answer
Insert value in identity
SQL
37 votes249 views3 answers
Duplicate records in sql
SQL
0 vote252 views2 answers
Mysql password error create datbase
SQL
10 votes277 views2 answers
Tsql merge example
SQL
1 vote264 views1 answer
Mysql decimal allow negative values?
SQL
10 votes254 views4 answers
Join with multiple conditions sql
SQL
3 votes292 views1 answer
Sql double index
SQL
0 vote317 views1 answer
Trigger
SQL
1 vote240 views1 answer
Mysql average of multiple columns
SQL

Share