[AccessD] "Like" operator help

Paul Hartland (ISHARP) paul.hartland at isharp.co.uk
Fri Jul 8 08:37:51 CDT 2005


If I remember rightly I think it's something like

	Like '" & [YourField] & "*'"

	Like SingleQuoteDoubleQuote & [YourField] &
DoubleQuote*SingleQuoteDoubleQuote

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: 08 July 2005 14:25
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] "Like" operator help

I should clarify that I did get:

Like "ty*"

to work, but I want to leave it to the user to enter the letter(s).
And, I am using A2K

>>> John.Clark at niagaracounty.com 7/8/2005 9:20 AM >>>
This is probably beyond simple, but I really don't use it very often, and I
just ran into a problem.

I am trying to whip up a table of approximately 20,000 drugs. Many of the
drug listings are actually the same drug, but with different strengths. For
example:

Field5	ID	Field1	Field2	Field3	Field4	Field6	Field7
ABILIFY 1 MG/ML
SOLUTION	13	BEX	59148-0012-15	2.31031		0
OTSUKA
AMERICA
ABILIFY 10 MG
TABLET	14	BEX	59148-0008-13	10.04479		0
OTSUKA
AMERICA
ABILIFY 15 MG
TABLET	15	BEX	59148-0009-13	10.04479		0
OTSUKA
AMERICA
ABILIFY 20 MG
TABLET	16	BEX	59148-0010-13	14.20458		0
OTSUKA
AMERICA
ABILIFY 30 MG
TABLET	17	BEX	59148-0011-13	14.20458		0
OTSUKA
AMERICA
ABILIFY 5 MG
TABLET	18	BEX	59148-0007-13	10.04479		0
OTSUKA
AMERICA

I want to build a query that let you type in Tylenol and get to that drug,
or even "T" and get to that point of the list, where the "t"s are located. I
tried using a "Like" statement in the query, but it didn't work. How is this
done?

Thank you!

John W Clark
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list