/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

5 votes117 views2 answers
Mysql drop table cascade
SQL
5 votes115 views3 answers
String concatenation sql server
SQL
6 votes112 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote103 views1 answer
Postgresql inline table
SQL
4 votes114 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
24 votes123 views6 answers
Rename a column in sql server
SQL
0 vote105 views1 answer
10000000000000000000 am to meters
SQL
3 votes125 views2 answers
MySQL query to get column names
SQL
1 vote124 views1 answer
Mysql strict_trans_tables
SQL
0 vote79 views1 answer
Oracle list all stored procedures
SQL

Share