/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 vote157 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote186 views1 answer
Alter database name script
SQL
-1 vote204 views1 answer
Minus vs except in sql
SQL
1 vote151 views1 answer
Pl sql insert into table
SQL
0 vote143 views1 answer
Mysql convert charset
SQL
1 vote149 views1 answer
Customer using hdfc bank sql query
SQL
5 votes158 views4 answers
Mysql update column with value from another table
SQL
0 vote145 views1 answer
Get current date data in mysql
SQL
0 vote177 views1 answer
Mariadb change column type
SQL
4 votes164 views1 answer
For loop postgresql
SQL

Share