Thank you, it works perfectly (and makes the database much simpler).
GC
________________________________
De : [email protected] [mailto:[EMAIL PROTECTED] De la part de
Lonnie Johnson
Envoyé : vendredi 28 décembre 2007 15:19
À : [email protected]
Objet : Re: [ms_access] Query on a substring
Lookup "wildcard" in the help section. The jest of it is...
SELECT MYFIELD FROM MYTABLE WHERE MYFIELD LIKE '*ABC*'
This will return such as
ABC
1ABC
LAABCLA
ABCSS
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us <http://www.prodev.us>
----- Original Message ----
From: Clauss Gilbert <[EMAIL PROTECTED]
<mailto:gilbert.clauss%40insee.fr> >
To: [email protected] <mailto:ms_access%40yahoogroups.com>
Sent: Friday, December 28, 2007 4:21:55 AM
Subject: [ms_access] Query on a substring
Is there a way, without VBA, to make a query on a text field of a
table, with such an option : the field contains the substring "abc",
anywhere in the field ? Can the substring be used in this case ?
(it seems to be easy with the usual "find" option in a table or from a
form, but i can't find the way to do se the same in a query with SQL or
with the graphic interface).
Thank you
Gilbert Clauss
[Non-text portions of this message have been removed]
__________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
<http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
