Larry,

Thanks, I found that by using the % wild card on either side of the search and using LIKE works. I currently using: (cSearch is the variable filled with the search request - basically cSearch = "%" + Alltrim(input) +"%")

SELECT customer.cust_id, customer.username, customer.firstname,;
customer.lastname, customer.orgname;
FROM customer;
WHERE customer.username LIKE ?cSearch;
OR (customer.lastname LIKE ?cSearch);
OR (customer.orgname LIKE ?cSearch);
ORDER BY customer.username, customer.lastname,;
customer.firstname


>>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) //:^)