/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 vote129 views1 answer
Mysql login console
SQL
0 vote157 views1 answer
Command line mysql xampp
SQL
0 vote128 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote128 views1 answer
What are the aggregate function in sql
SQL
1 vote149 views1 answer
Query for all indexes in table postgres
SQL
4 votes139 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote133 views2 answers
Starting mysql service from mac
SQL
0 vote161 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
1 vote125 views1 answer
Sql server reseed single table
SQL
0 vote146 views1 answer
Mysql join column order By and group By
SQL

Share