/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 vote195 views1 answer
Get records in sql according to month name and count
SQL
0 vote200 views1 answer
How get data from database if id not found then search another column
SQL
1 vote205 views1 answer
Oracle stop
SQL
3 votes206 views2 answers
Brew start mysql
SQL
1 vote222 views1 answer
Increase existing date in sql
SQL
0 vote209 views1 answer
Sql server synonym
SQL
2 votes214 views1 answer
Sql update from different table
SQL
0 vote201 views1 answer
Pass array parameter to stored procedure c#
SQL
15 votes212 views3 answers
Find duplicate keys in mysql
SQL
1 vote199 views1 answer
Index a database column sql
SQL

Share