>>>What is the string function to determine if a string exists within another string or field? For example I am wanting to display all inventory records that have the string 'MIC' anywhere in the description field. Is there a function to do this in VFP?
>>>
>>>Thanks,
>>
>>There is bunch of them. Look at AT() or OCCURS().
>
>Thanks Ed,
>
>One other question,
>
>Lets say I want to select all records that have "WASH" in the description...the occurs() or at() functions work great...Is there a function that I could use that would not include records that have "WASHINGTON" in the description? In other words I only want to match whole words...
>
>Thanks,
There is no 100% reliable solution here. I guess searching for SPACE(1)+ "WASH" or for "WASH"+SPACE(1) will give you something.
Edward Pikman
Independent Consultant