Using multiple Like(s) * in a query

[paulquinlan100]

Hi

Just a quick one, is there a way of selecting using Like* multiple
times in a query in a similar way to using IN e.g. IN("a","b","c")
rather than having to use multiple OR statements?

Thanks for any suggestions
Paul

 

[Steve Schapel]

Paul,

Using your example:
Like "[a-c]*"
.... or:
Like "[a,b,c]*"