/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 vote303 views1 answer
Sqlalchemy on delete set null
SQL
0 vote260 views1 answer
How to find database collation in postgres
SQL
1 vote267 views1 answer
Psql client write to bash variable
SQL
1 vote263 views1 answer
Loading local data is disabled mysql
SQL
0 vote273 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote259 views1 answer
Mysql workbench primary key
SQL
6 votes321 views2 answers
Install psql mac
SQL
0 vote275 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote264 views1 answer
Mysql wsrep ls
SQL
0 vote302 views1 answer
SQL server datetime compare
SQL

Share