/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

2 votes286 views1 answer
Mysql now format
SQL
0 vote270 views1 answer
Joins vs includes
SQL
1 vote281 views1 answer
Events mysql
SQL
2 votes252 views1 answer
Oracle sql drop column if exists
SQL
0 vote288 views1 answer
Get a list of tables and the primary key
SQL
0 vote267 views1 answer
Find wordpress version in database
SQL
0 vote283 views1 answer
Set a value by excuting stored procedure
SQL
2 votes267 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote277 views2 answers
Insert into
SQL
0 vote277 views1 answer
PSQL qith variables
SQL

Share