IN and LIKE command combination, Possible?

[hengsin]

In the WHERE clause....

.... where area = "india" or area "china"

can be equivalent to:

where area IN("india","china&quot.

What if:
where area like "a*" or area like "b*"

How to put the Like and IN command together?

 

[swampBoogie]

There is no equivivalent of in for like.

Use ' instead of " as string delimiter in SQL.

 

[cheerio]

WHERE LEFT(area,1) IN ("a","b&quot