Jump to content

Apostrophe Issue


Recommended Posts

Hi All,

I wrote code that works perfectly.  However when I sent it to IT to automate they added the following code.

Declare @query nvarchar(max)

Set @query = N'

The apostrophe after the N interferes with my code. 

where b.comment like '%address%' and b.comment not like '%email%'

When SQL reaches the '%address it causes an error.  Any thoughts?



Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...