>>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