/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 vote199 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote190 views1 answer
Less than and between in sql query
SQL
1 vote184 views2 answers
Postgresql list columns
SQL
0 vote207 views1 answer
How to get data from 2 database
SQL
0 vote183 views1 answer
Systemverilog unique constraint unique values
SQL
2 votes186 views4 answers
Check timezone of mysql database
SQL
2 votes126 views1 answer
Sql select in list
SQL
0 vote191 views1 answer
Join in update query in mysql
SQL
0 vote208 views1 answer
Sql query inline if
SQL
5 votes173 views1 answer
Mysql get last day of month
SQL

Share