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