>>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,