I see, that explains it.  Thanks for the info!

enzo c",)?
http://www.tropangwatakwatak.tk

-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Friday, January 03, 2003 11:39 AM
To: sql language
Subject: [sql_language] Re: SQL "LIKE" isn't working


If you are using the Jet OLEDB Provider, you need to use ANSI SQL, not Jet
SQL:
www.adopenstatic.com/faq/likequeries.asp

% is the ANSI SQL multiple character wildcard
* is the Jet SQL multiple character wildcard

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Enzo Zaragoza" <enzaux@g...>
Subject: [sql_language] Re: SQL "LIKE" isn't working


:
: I'm using ADO 2.6 and Microsoft.Jet.OLEDB.4.0.  Why?  Is '*' working on
your
: LIKE statement in VB?
:
: enzo c",)T
: http://www.tropangwatakwatak.tk
:
: -----Original Message-----
: From: Haslett, Andrew [mailto:andrew.haslett@i...]
: Sent: Thursday, January 02, 2003 8:50 PM
: To: sql language
: Subject: [sql_language] Re: SQL "LIKE" isn't working
:
:
: Maybe it's the driver?
:
: Are you using ODBC/OLEDB?  Versions??
:
: -----Original Message-----
: From: Enzo Zaragoza [mailto:enzaux@g...]
: Sent: Thursday, 2 January 2003 9:35 PM
: To: sql language
: Subject: [sql_language] Re: SQL "LIKE" isn't working
:
:
:
: Nope the conSender is opened on my form load event.  Actually the
: '%' did the trick
: I dunno why '*' wont work.
:
: Thanks,
:
: enzo c",)(tm)
: http://www.tropangwatakwatak.tk
.