/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 vote242 views1 answer
Install sql server in ubuntu 20.04
SQL
3 votes248 views1 answer
Oracle sql commit example
SQL
8 votes236 views1 answer
Database backup in mysql server recovery
SQL
2 votes236 views4 answers
Duplicate record mysql
SQL
0 vote245 views2 answers
Suse stop MySQL
SQL
6 votes233 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote252 views1 answer
Tsql delete all rows
SQL
6 votes256 views2 answers
Oracle trigger
SQL
15 votes238 views3 answers
Find duplicate keys in mysql
SQL
0 vote229 views1 answer
Postgress append string in select
SQL

Share