>I'm tiring to do the equivalent of this through odbc:
>Select * from customers where lastname = "L"
>In vfp this returns all the customers that have a last name starting with "L".
>Through ODBC this return 0 records.
>
>Next I tried to use the SQL "IN" syntax:
>Select * from customers where lastname IN ("L")
>Again in vfp this returns all the customers that have a last name starting with "L" but through ODBC I get 0 records.
>
>Has anyone ever overcome this seemingly simple problem?
Use LIKE operator
Select * from customers where lastname LIKE 'L%'
--sb--