/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 vote187 views1 answer
Define a variable in mysql from select
SQL
0 vote170 views1 answer
What alter does in db
SQL
0 vote203 views1 answer
Hashpass
SQL
1 vote175 views1 answer
How to drop function in sql
SQL
1 vote174 views1 answer
Timestamp in sqlite
SQL
1 vote129 views1 answer
Flask-sqlalchemy filter_by contains
SQL
23 votes181 views3 answers
Sql where contains part of string
SQL
4 votes239 views2 answers
Mysql alter table set column unique
SQL
12 votes170 views4 answers
Mysql ifnull
SQL
0 vote163 views1 answer
Distinct data types in a table sql query
SQL

Share