/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 vote213 views1 answer
Select * from mysql.proc
SQL
5 votes203 views2 answers
Sql number columns
SQL
0 vote197 views1 answer
VSCode SQL Server Connection error
SQL
0 vote186 views1 answer
Sql max min
SQL
0 vote178 views1 answer
Check index sql server
SQL
0 vote184 views1 answer
Mysql local password denied
SQL
0 vote226 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
13 votes205 views2 answers
Sql join 3 tables
SQL
4 votes191 views1 answer
Delete record mysql query
SQL
5 votes156 views1 answer
Copy table from one database to another mysql
SQL

Share