Apostrophe Issue

[markg1972]

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?

Thanks!!

Mark