/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 vote295 views1 answer
Pl sql insert into table
SQL
0 vote279 views1 answer
Online sql testing tool
SQL
0 vote306 views2 answers
Mysql calcular idade
SQL
0 vote232 views1 answer
Sql count how many times a value appears
SQL
0 vote281 views3 answers
Group_concat sql server
SQL
0 vote278 views1 answer
Get only structure database mysql
SQL
0 vote286 views3 answers
Insert or ignore postgres
SQL
0 vote297 views1 answer
Sql cnvert bit to nvarchar
SQL
0 vote266 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote284 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL

Share