Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INLIST syntax
Message
From
07/02/1997 20:07:59
 
 
To
07/02/1997 19:06:05
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00019640
Message ID:
00019654
Views:
32
>I have a TEST field which contains something like 1,2,5,18,23,32,33,34.
>
>I would like to compare a value within this field value.
>
>For example, I would like to do something like
>
>IF INLIST(TEST,'23')
> ...
>ENDIF
>
>But, this is not working. How can I process this validation?

if ",23," $ ","+alltrim( TEST)+","
...

This the best way I know. Please note that it's very important to add commas before and after TEST (otherwise you can find 23 in 423 for example even if 23 is not there). A good idea is to keep ",1,2,5,18,23,32,33,34," in TEST, not "1,2,5,18,23,32,33,34". It's faster.

Vlad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform