/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 vote136 views1 answer
Drush sql-dump
SQL
0 vote246 views1 answer
How to use select union and loop
SQL
1 vote163 views1 answer
Sql and
SQL
0 vote134 views1 answer
Mysql remove tabs from string
SQL
0 vote134 views1 answer
Minus equivalent in my sql
SQL
0 vote155 views2 answers
Select last 30 days sql
SQL
2 votes153 views1 answer
Guid to string sql
SQL
5 votes147 views1 answer
Add column table sql default value
SQL
3 votes140 views1 answer
Oracle apex warning message
SQL
0 vote168 views1 answer
How to check foreign key constraint in sql
SQL

Share