Posted by Steve on 09/20/05 14:59

How do I get a single quote (') in a NVARCHAR string in MS SQL Server?

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

Obviously this is invalid as the single quote before "blah" would end the
varchar string.

How do I get round this?

• Next in forum: Re: Single quote in NVARCHAR string?
• Prev in forum: Re: How to update 1000s of items in 50 tables
• Thread view: Single quote in NVARCHAR string?

[Reply to this message]