Oh, WOW! I guess before I had tried:

select count(*) from BLacklist

   where CHARINDEX('crap1 or what ever crap they may send', BlackListResponse) > 0

but not the other way around!

Sweet!

Thanks for...

Well this was closer (and thanks for your help!) but still this has its own problems. For example this still returns one row if the string was 'carry was playful'...

I should also note that I have tried using padindex/charindex but this still doesn't help much...

Example:

select count(*) from BLacklist

   where CHARINDEX('crap', BlackListResponse) > 0

does return a value

select count(*) from...