Edward,

Thank you for the reply. I am in fact storing price in a separate field, however, I need to extract information from a memo field (that is a program generated memo field). So my question still stands as I need to find an occurence of a value with a wildcard within a memo.

If you are aware of using ATC() with a wildcard, please let me know. Or if you know of another function like this.

TIA

>>Hello all,
>>
>>I am using the ATC() function to locate a substring within a memo field. I will find the string I am looking for and determine the starting position and length of the substring to return the needed substring. This was working because I assumed a certain character would never be used in the memo field and this character is now being used. Now I want to search for that string with only numeric values following it. For example, I want to extract a price from a memo field that has and '@' sign followed by a space and then some numeric value.
>>
>>Can I use the ATC() function to search for a string with a wildcard for numerics, and if so what is the wildcard? Or is there another function I can use to do this?
>>
>>TIA
>
>You could write your own ('wildcard') search calling ATC() for each '@' occurence and then checking subsequent characters.
>Anyway, given time-consuming constraints, if any exist, I would consider changing the way you store data. It might be reasonable to keep price in separate field instead of memo.