>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

Try SET ANSI OFF
It performs the same function for SQL queries as SET EXACT OFF does for string comparisions in VFP code.