Select records based on multiple values 1

[paulcat]

How can I build an efficient SQL string to select records from a table with a field called STATUS that is 2 characters wide and can contain the string "00" to "99", if I only want to select the records with a 88,89,90,91,96,97,98? I know I can do it with multiple OR's, but there must be a more efficient way. In Clipper, I used to say "FOR STATUS $ '88,89,90,91,96,97,98'".

 

[RickCole]

Select STATUS from tablename where STATUS in ('88','89','90','91','96','97','98')

Rick.