>>I have a character field zip c(5) containing zipcodes. I need to set a filter to select the bad entries which contain alpha characters. This is done in Access code using the LIKE function (not like('#####'), but VFP handles LIKE differently. This would also seem to be a simple matter but I can't seem to find the answer. I could find a bad entry by parsing the values but that doesn't serve my need to set a filter.
>>
>>Any thoughts?
>
>
>We found that this techniques does not prevent from input of bad Zip codes.
>We got a 100K rows table with USA table with ZipCodes, Cityes and States, which reduce number of bad codes

You are right. It wasn't intended to be a positive check. Only a basic test to see if all the characters were actually numbers.

Thanks