Concat single Quote(') with String in SQL Server

Question

At mssql I want concat ' and 1 string

Example: Concat ('My name',''')

Ouput : My name'

Which dbms are you using? ANSI SQL has || as concatenation operator, while some products have a concat() function. — jarlh
– jarlh, Commented Apr 4, 2018 at 13:39
Simply: 'My name' || ''''. I.e. double the single quote inside a string literal. — jarlh
– jarlh, Commented Apr 4, 2018 at 13:42

DineshDB · Accepted Answer · 2018-04-04 13:39:48Z

11

Double-up the single quote character

Try this:

SELECT CONCAT('My name','''')

Ouput:

My name'

answered Apr 4, 2018 at 13:39

DineshDB

6,2238 gold badges38 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daniel Marcus · Accepted Answer · 2018-04-04 14:01:08Z

9

Or you can use '+':

select 'My Name'+''''

answered Apr 4, 2018 at 14:01

Daniel Marcus

2,6841 gold badge10 silver badges13 bronze badges