General information
Category:
Coding, syntax & commands
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only