Thanks for the info. The SQL like works fine.
Are there any reasons to choose one over the other?

Also what would work for a logical field? I have a form property with a nValue of 0, 1 or 2 and I want to select on obsolete = .t., .f. or either.

>>Can you use a wildcard in the where clause of a select statement?
>>
>>
>>if thisform.cToShow = "All"
>> lcCatToShow = "" &&>>> This is where I want a wildcard
>
>You can use wildcarding in at least two ways.
>Standard DOS-style wildcarding (? matches any single character, * any number of characters) using the LIKE() function in your WHERE clause rather than equivalence; IOW, rather than CatLink.Catagory == lcCatToShow , you'd say LIKE(lcCatToShow,CatLink.Catergory,) .
>
>Alternatively, you can use the SQL LIKE Clause (% == *, _ == ?), so that instead of CatLink.Catagory == lcCatToShow you'd say CatLink.Category LIKE lcCatToShow.