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