Posted by Aaron Bertrand [SQL Server MVP] on 09/20/05 15:34

> e.g. SELECT @strsql = "SELECT * FROM tblTest WHERE Field1 Like 'blah''

Why is this in a variable? Why don't you just execute

SELECT * FROM tblTest WHERE Column1 = 'blah'
or
SELECT * FROM tblTest WHERE Column1 LIKE 'blah%'

?

• Next in forum: Re: Single quote in NVARCHAR string?
• Prev in forum: Re: Single quote in NVARCHAR string?
• Thread view: Re: Single quote in NVARCHAR string?

[Reply to this message]