Re: ADOQuery filter

From: "Paul Scott" <paul.scott@xxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 18 Apr 2007 13:08:33 +0100

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

Follow-Ups:
- Re: ADOQuery filter
  - From: Alan T

References:
- ADOQuery filter
  - From: Alan T

Prev by Date: ADOQuery filter
Next by Date: Feed back from Ado Query Component
Previous by thread: ADOQuery filter
Next by thread: Re: ADOQuery filter
Index(es):
- Date
- Thread