I agree with Al, a child cursors seems like simpler and cleaner solution.
>
>I need to store a series of numbers into a field (e.g. 1, 34, 22, 33, 3333, 7 and so on) so that later in the program it can be determined if a certain number is present in this "array" of numbers. Originally I was creating an array (based on this series of numbers), converting the array into a string, storing the string in a memo field; then retrieving the string and converting it to array. Now I am thinking that maybe there is a more efficient way. What if I store this series of numbers as a string of this type:
>"1,34,22,33,3333,7" (basically converting each number into a string and then concatenating them). How would I then find out if a certain number (e.g. 3) is in the list? Using AT() will not give me the right result since character "3" is in the string but not the number 3. Anybody can suggest a more efficient method of storing this series of number and comparing them?
>
>TIA.
--sb--