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