Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find a bad zipcode
Message
From
17/11/2006 12:47:31
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Find a bad zipcode
Miscellaneous
Thread ID:
01170759
Message ID:
01170759
Views:
49
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?
Next
Reply
Map
View

Click here to load this message in the networking platform