/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 vote211 views1 answer
Sql combine results from two tables
SQL
0 vote224 views3 answers
Java hide mysql login credentials
SQL
7 votes214 views1 answer
Connect mysql docker
SQL
0 vote217 views1 answer
Equi joins in oracle
SQL
0 vote196 views1 answer
Clone table structure mysql
SQL
6 votes223 views2 answers
If not exists insert sql
SQL
0 vote228 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote221 views1 answer
Sql last 3 rows
SQL
2 votes236 views1 answer
Pdo mysql insert
SQL
0 vote213 views1 answer
Mssql view column data type
SQL

Share