>>Doesn't that work for you?
>
>It does, but the second one is not flexible and the first one is two commands. THe only reason is that in SQL92 or whatever the standard that VFP is based on supports that syntax.

Ah, OK. I didn't realize that was SQL92 standard.