/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 vote304 views2 answers
Sql drop view if exists
SQL
1 vote308 views1 answer
SQL server query column yes or no
SQL
0 vote324 views1 answer
Get schema of table sql
SQL
1 vote331 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote294 views1 answer
Create column that already exists mysql
SQL
6 votes318 views2 answers
Database url postgres
SQL
1 vote306 views1 answer
Oracle create program if no exists
SQL
0 vote329 views1 answer
Sqlcmd no headers
SQL
0 vote320 views2 answers
Athena drop partition
SQL
0 vote334 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL

Share