Hi Mathew,
1) You can use function INLIST()
?INLIST(alltrim(fruit.id),"13","14","15")
1) or AT()/ATC with formated data
?ATC(":"+alltrim(fruit.id)+":",":13:14:15:")
MartinJ
>Hi All,
>
>I have a fruit table which contains the following...
>
>ID Items
>-- -----
>1 apple
>2 pear
>3 banana
>4 cherry
>.
>.
>13 watermelon
>14 orange
>15 mango
>
>and I want to return the Items (description) based on the id stored in this format -> n:m:o:p.
>
>Here is an example, when I used the ATC(alltrim(fruit.id),"13:14:15"), with fruit id = 1 (starting with the first record), VFP returns the following...
>
>apple
>watermelon
>orange
>mango
>
>instead of 'Apple'
>
>Is there a way to return the item description based on the exact match? Is there other ideas or suggestons using "13:14:15" format?
>
>TIA