/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 votes183 views1 answer
While loop sql
SQL
0 vote183 views1 answer
Value of sold product using having and group by in sql
SQL
12 votes186 views2 answers
Delete entries in postgresql
SQL
1 vote167 views2 answers
T-sql random number for each row
SQL
5 votes182 views2 answers
Oracle list columns schema
SQL
0 vote162 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote201 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote189 views1 answer
Ajax error exception handeling
SQL
-1 vote183 views1 answer
Capitole toulouse
SQL
1 vote182 views1 answer
Md5 encryption for existing records
SQL

Share