/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 vote121 views1 answer
Oracle apex run 404
SQL
0 vote120 views1 answer
Oracle select invalid views
SQL
0 vote136 views1 answer
Mysql update set sum
SQL
1 vote123 views1 answer
How to drop function in sql
SQL
0 vote123 views1 answer
Mysql timediff
SQL
27 votes127 views4 answers
Get all tables with column name sql
SQL
0 vote141 views1 answer
Connect to ssms with python
SQL
0 vote113 views1 answer
Mysql error 1452
SQL
5 votes113 views1 answer
Sql first day of current year
SQL
1 vote123 views1 answer
Crontab every month
SQL

Share