/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

19 votes363 views6 answers
Sql create table
SQL
0 vote353 views1 answer
Kotlin sqlite delete row
SQL
0 vote403 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
3 votes346 views2 answers
Pl sql escape '
SQL
0 vote373 views2 answers
Add colum in sql
SQL
0 vote371 views1 answer
Sql join on a subquery
SQL
3 votes383 views1 answer
Get current month last date in sql server
SQL
-1 vote374 views2 answers
Sql truncate number
SQL
0 vote385 views2 answers
Oracle chain rules
SQL
2 votes361 views1 answer
Oracle kill session by sql_id
SQL

Share