/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 vote115 views2 answers
Dumping sql table
SQL
1 vote107 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote108 views2 answers
Postgresql get long running queries
SQL
1 vote104 views1 answer
Table information in sql server
SQL
0 vote97 views2 answers
Mysql unique two columns
SQL
0 vote102 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote165 views1 answer
How to rename a database in tsql
SQL
0 vote103 views1 answer
Set column in all row mysql
SQL
0 vote108 views1 answer
Sql select column name like from multiple tables
SQL
32 votes103 views6 answers
Insert select
SQL

Share