>Cindy,
>
> I guess, you're right. This is very important question, so keep it for DevCon, please.
I've tested this with up to 21 items in the IN () statement without problem. However, in my test, the length of each item in the list matched the width of the field. Note that if the length of the field is wider than the items in the list and ANSI is set to ON the shorter items are padded with spaces. This will cause something like "CHI" in the list of items not to return a value for "CHICAGO" in the city field.
George
Ubi caritas et amor, deus ibi est