Re: ADOQuery filter

Thanks.

Can I make it case insensitive?

"Paul Scott" <paul.scott@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:op.tqzaojuldgyzbd@xxxxxxxxxxxxxxxxxxxxxxxx
On Wed, 18 Apr 2007 05:24:02 +0100, Alan T <alanpltseNOSPAM@xxxxxxxxxxxx>
wrote:

How do I make the filter something like 'LIKE' in SQL?
eg.
Name = 'John*'
so returns 'Johnny', 'Johnson', 'johnny', 'johnson'


In SQL(server) (and Access-via-ADO) the wild card is a percent "%" not an
asterisk

name like 'John%'

--
Paul Scott
Information Management Systems
Macclesfield, UK.


.

Relevant Pages