Hi,

I found out the reason:

if I use "%string%" instead of "*string*" it worked fine. I need to
check the SQL standard to see what is the standard character for
wildcards.

It definitely is a Microsoft problem, not ruby's. Sorry for the noise.

Shannon

On Sun, 15 Dec 2002 22:16:28 +0900
Shannon Fang <xrfang / hotmail.com> wrote:

> Hi,
> 
> I got a strange problem while using ADODB with Access. In ruby, I use
> the following SQL:
> 
> SELECT ID, SENDER FROM MESSAGE WHERE SENDER LIKE '*Deals / deals-network.com*'
> 
> it returned no records, while I use the same SQL in Access, it returned
> 2 records.
> 
> I changed the "SENDER LIKE" clause to "SENDER=", it worked fine in Ruby.
> 
> Did anyway have the same problem? Maybe you can give me a hint if it is
> an ADODB/Access bug, Ruby problem, or my problem...
> 
> 
> Thanks!
> Shannon