/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 vote341 views1 answer
Oracle user last connected
SQL
1 vote348 views1 answer
Select not matching data with join table
SQL
4 votes350 views1 answer
Describe table mysql
SQL
1 vote337 views1 answer
Loading local data is disabled mysql
SQL
0 vote330 views1 answer
Sql server whoami
SQL
0 vote340 views1 answer
Sql delete row from table where id
SQL
0 vote289 views1 answer
Sqlalchemy existing database
SQL
2 votes370 views1 answer
Revokeprivileges mysql
SQL
1 vote338 views2 answers
Update with inner join sql server
SQL
1 vote349 views1 answer
Duplicating a MySQL table with all the data Command
SQL

Share