Several like statements

[7724]

Hi,

Quick and hopefully question. Say I have several 'Like' statements in a query, is there a cleaner way to clean it up:

SELECT * 
FROM tbl
WHERE col LIKE '%value1%'
OR col LIKE '%value2%'
OR col LIKE '%value3%'
OR col LIKE '%value4%'
OR col LIKE '%value5%'
OR col LIKE '%value6%'

[r937]

nope