SQL: Combine LIKE and IN statement?

Can anyone tell me how to improve the following:

Select tbl.city
From tbl
Where tbl.city like 'B%' or
tbl.city like 'G%' or
tbl.city like 'R%'

I was trying:
Where tbl.city like in ('B%', 'G%', 'R%') But apparently this is not the right way.

Thanx,
Bob Received on Wed Feb 11 2004 - 12:35:04 CST