Using LIKE *

Thread view:

Thread rating:

Ted - 14 Aug 2007 19:39 GMT

Are there any known issues in using LIKE * in an SQL for ADO?

Douglas J. Steele - 14 Aug 2007 22:55 GMT

Yeah. The wildcard in ADO is %, not *.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Are there any known issues in using LIKE * in an SQL for ADO?

Jan Hyde (VB MVP) - 15 Aug 2007 09:05 GMT

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com>'s
wild thoughts were released on Tue, 14 Aug 2007 17:55:24
-0400 bearing the following fruit:

>Yeah. The wildcard in ADO is %, not *.

IIRC % is that ASNI standard for LIKE, * is used with
MATCHES.
--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde

VB Forum / Database Access / August 2007