• I like the solution above from gbritton1, but nother way of doing which is probably less efficent but perhaps also easier to understand would be

    select m.description from @message m

    where not exists (select 1 from @keyword k where k.id = @id and m.Description not like '%'+k.token+'%')

    Tom