/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 vote364 views2 answers
How to take recent row without limit in mysql
SQL
0 vote372 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote341 views1 answer
Sql change date format
SQL
23 votes335 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote365 views1 answer
Difference between 2 query results sql server
SQL
5 votes360 views4 answers
Select random rows sql
SQL
0 vote384 views1 answer
Oracle string length
SQL
0 vote333 views1 answer
Sql count null as 0
SQL
6 votes351 views4 answers
Remove spaces sql server
SQL
0 vote351 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL

Share