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 ----- Original Message ---- From: Clauss Gilbert <[EMAIL PROTECTED]> To: [email protected] 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 [Non-text portions of this message have been removed]
