/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 vote330 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote375 views1 answer
Show tables in cassandra cql
SQL
8 votes350 views3 answers
Oracle auto_increment
SQL
0 vote334 views1 answer
Add column not null with default value postgres
SQL
1 vote358 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
16 votes347 views6 answers
Mysql find and replace
SQL
0 vote354 views1 answer
Linebreak sql
SQL
2 votes406 views1 answer
Remove foreign key constraints in postgres
SQL
2 votes347 views1 answer
Update trigger
SQL
0 vote345 views3 answers
Joins and views sql
SQL

Share