>>>>I am trying to create a view to take a variable that is filled with a search string and query that against a SQL table that will partially match the SQL table field. I can find the records of the search string matches the whole table field but if only a part of the search string is found in the record it returns nothing...Can anyone help here? Thanks again!
>>>>
>>>>Gary
>>>If I understand correctly your problem may be one or both of the following
>>>1) Try SET EXACT OFF
>>>2) In your SELECT statement make sure that you have field=trim(variable)
>>>The point being ensuring that variable is on the right side ot the "="
>>>
>>>Hope this helps (HTH) //:^)
>>
>>you can also write the WHERE clause:
>>
>>... where FieldName like '%&MyVar.%'
>>
>>This will return rows where your variable text string is anywhere in the field, not just at the beginning of the field.
>
>
>Mark,
>
>Excuse me for butting in but, will "where FieldName like '%&MyVar.%'" run faster than
>"where ATC(myvar, mytable.myfield) > 0"? I am also trying to find a fast way of searching
>for strings inside of a character field.
>
>Thanks
>Jerry Tovar
You should look at the phDbase utility