/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 vote206 views1 answer
Sql quary stuf
SQL
0 vote196 views1 answer
Sql order by except one row
SQL
10 votes244 views1 answer
Oracle all_dependencies
SQL
0 vote207 views2 answers
What is the default password for sql server sa
SQL
1 vote198 views1 answer
Load mysql dumb
SQL
60 votes550 views6 answers
Add column in sql
SQL
0 vote185 views1 answer
Insert array into mysql column
SQL
0 vote173 views1 answer
Flask sqlalchemy update row
SQL
1 vote175 views2 answers
Populate sql table with random data
SQL
1 vote171 views3 answers
How to filter repeated same result using sql query
SQL

Share