>>>>Hi Larry.. what should I use instead of "$"?
>>>
>>>If you have a table with only a few dozen records then it won't matter. If it's bigger than that you might consider using PHDBase.
>>
>>Hi Mike - what could I do in SQL for a string search?
>
>As mentioned, it is not recommended to use $.
>
>Here, for example, on the Universal Thread, where the messages table is having about 50 Megs of data, we are using PHDBase for that. As you can see, the result is immediate as oppose to several hours if you would use $.

thanks Michel. I am stuck with the vfp database...not my choice..