/SQL/String concatenation sql server

String concatenation sql server

Concatenation in sql

We use "||" to concatenation in Sql

example:
WHERE LOWER(FIRST_NAME || LAST_NAME)  LIKE '%d%' ;

4

Sql server concat string and int

SELECT 'Comments: ' + CAST(9 AS varchar(12)) AS Result;

1

Source: database.guide

String concatenation sql server

SELECT CONCAT('Comments: ' , CAST(9 AS varchar(12))) AS Result;

0

Similar codes

0 vote9.7K views1 answer
Postgresql delete type
SQL
0 vote172 views1 answer
Mssql current date
SQL
1 vote182 views2 answers
Postgres copy table from one schema to another
SQL
4 votes263 views4 answers
Remove duplicate old value in mysql
SQL
16 votes181 views4 answers
Ascending order mysql
SQL
2 votes213 views2 answers
Python escape string for sql
SQL
0 vote178 views2 answers
How to know the character set of an oracle databes
SQL
0 vote190 views1 answer
Tsql pad left
SQL
1 vote171 views2 answers
String to date postgres
SQL
0 vote207 views1 answer
Datagrip go to line
SQL

Share