'Contains' in SQL?

[ilovetorun]

I know that 'Like' in SQL can be used like 'Contains' in CFML if wildcards are attached to the keyword/text-string you're looking for. But I've recently found that 'Like' can't be used with 'ANY'. Is there a way to to a CFML-like 'Contains' in SQL?

 

[JNC73]

Yep it's the function IN


WHERE fieldname IN (value1, value2, etc.)

Hope this helps

JNC73

 

[ilovetorun]

Thanks! I'll try that directly!