/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 vote291 views2 answers
Call to undefined function mysql_query()
SQL
0 vote262 views1 answer
Json_remove mysql
SQL
0 vote268 views2 answers
Sql searching via key word
SQL
0 vote290 views1 answer
Postgresql replace html tags from string
SQL
1 vote279 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote267 views1 answer
Horizontal join sqlite
SQL
0 vote279 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
7 votes257 views2 answers
N highest salary in sql
SQL
5 votes272 views3 answers
Select tables from mysql database
SQL
7 votes281 views2 answers
Oracle sql drop index
SQL

Share