>>>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%';
>
>
>Excellent! Damn thing worked :-) Didn't know i had to replace * with % . Any other such replacements?
>
>
>Alesh

Yes, there is several but it varies from system to system. Find a good ODBC ref book.
Remember that not all systems follow the standard completely.
Good Luck


Jeff