/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 vote358 views2 answers
How to get max from each department in sql
SQL
1 vote350 views1 answer
Print all records of table in mysql
SQL
0 vote304 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote329 views1 answer
Import sql inside hide sql
SQL
15 votes307 views2 answers
How to drop database name in postgresql
SQL
0 vote316 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
2 votes320 views1 answer
Sql column values comma separated
SQL
0 vote309 views1 answer
Forcefully delete a row in mysql which has references
SQL
1 vote336 views1 answer
Oracle avg
SQL
6 votes353 views3 answers
Rename column ORACLE
SQL

Share