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

I usually use the '$' althogh have been told at() was faster.. but, I don't see how that could be measured.

select * from inventory where 'MIC' $ upper(descript)

BOb