Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kenneth Fisher Single Quotation Marks in SQL RE: Single Quotation Marks in SQL
aleksandr.milman
Valued Member
Points: 65
More actions
January 3, 2013 at 12:34 pm
#1573436
What about something simpler:
declare @q nvarchar(50), @sql nvarchar(100)
set @q = '''o''''neil'''
set @sql = 'print ' + @q + ''
print @sql
EXEC sp_executesql @sql
___________________________________
print 'o''neil'
o'neil