/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 vote340 views1 answer
DATE_SUB postgres
SQL
0 vote368 views1 answer
Oracle current timestamp insert statement
SQL
0 vote328 views1 answer
Sql not exists
SQL
0 vote333 views4 answers
Change schema in sql server
SQL
3 votes318 views1 answer
Sql select all
SQL
0 vote359 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote388 views3 answers
Sql parenthetical expression examples
SQL
3 votes313 views1 answer
What is having clause
SQL
9 votes318 views1 answer
Identity insert on sql server
SQL
2 votes361 views1 answer
Sql server: select column values as comma separated string
SQL

Share