Add single quote out put of the query

Question

0.00/5 (No votes)

See more:

Hi All,
In a variable i have following value

declare @var varchar(20)='T,1'

need to print the data as
'T','1'

Posted 13-May-14 0:06am

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

scottgp · Answer 1 · 2014-05-13T01:55:00

Doubling them up works, e.g.

SQL

declare @var varchar(20)='''T'',''1'''
print @var

'T','1'

Posted 13-May-14 1:55am

Comments

Nirav Prabtani 13-May-14 8:05am

my 5+