/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

-1 vote333 views1 answer
Capitole toulouse
SQL
10 votes357 views1 answer
Oracle view dependencies
SQL
3 votes357 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
3 votes365 views1 answer
Sql set null
SQL
0 vote338 views1 answer
Select row with latest date mysql
SQL
0 vote317 views1 answer
Check for directory in bash
SQL
0 vote318 views1 answer
Order by number of character in sql
SQL
0 vote338 views1 answer
How to to get current date in sql
SQL
49 votes379 views6 answers
Get duplicate records in sql
SQL
0 vote310 views1 answer
SQL Server format datetime
SQL

Share