/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 vote186 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
1 vote174 views1 answer
Mysql select if empty result
SQL
2 votes168 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote176 views1 answer
How to insert a uniqueidentifier in sql
SQL
3 votes176 views1 answer
Set default today mysql
SQL
-1 vote140 views10 answers
Delete Query in SQL Server
SQL
14 votes178 views4 answers
Import database through command line
SQL
0 vote167 views1 answer
Mysql pv progres
SQL
1 vote157 views1 answer
Mysql count words
SQL
0 vote134 views1 answer
Hangfire clean script
SQL

Share