Home Forums SQL Server 7,2000 T-SQL Compare Two sets of delimited string items RE: Compare Two sets of delimited string items

  • January 21, 2013 at 9:52 am

    #1579314

    This is how we fixed it:

    (@Issue is not null and exists

    (select 1 from IssueCodes where charindex(IssueCode, @Issue) <> 0 AND charindex(IssueCode, SPL.IssCode) <> 0)))

    Works like a charm!