Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determining Type of Field Contents
Message
 
To
29/07/1998 11:14:37
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00122322
Message ID:
00122328
Views:
15
>I'm trying to filter out all records that have number(s) in a two character field.
>
>Example:
>I want to filter the following records:
>
>1A
>A2
>AA
>B2
>BB
>etc.
>
>So that only the record with the two characters appear.
>
>AA
>BB

Rixon,

SET FILTER TO NOT (ISDIGIT(LEFT(Field,1)) OR ISDIGIT(RIGHT(Field,1)))
Previous
Reply
Map
View

Click here to load this message in the networking platform