>I'm using either Remote Data Object or Remote Data Control and I still have problems with this.
>This SQL statement doesn't return me any results, or errors:
>SELECT fname FROM AUTHOR WHERE fname LIKE 'bl*';
>
>fname is in access 97 db, set to text, required no, lenght 25
>
>If I use this SQL in Access, it will return me 2 results, what is perfect.
>
>Does anybody have any ideas, why VB would return me 0 results ?
>
>I tried using Remote Data Control or creating a RDOEnvironment & in it, connection, query & resultset, but still it's like banging it in the wall.
>
>
>All help or suggestions are highly appriciated.
>
>Thank you in advance.
>
>
>Alesh

Not sure but give this a try----
SELECT fname FROM AUTHOR WHERE fname LIKE 'bl%';