Ok, I assume you already know that this is done in the QBE (query by
example) pane of the Query Builder. What you want to do is insert your
"like" match in the Criteria cell, under the column you want to run the
match on. For example if you are looking for *foo* in the my_field column,
then in the Criteria cell, under the my_field column, enter:
Like "*foo*"
Here are the wildcard characters used by the Like Operator:
wildcard purpose
? a single character (0-9, Aa-Zz)
* any number of characters (0 to n)
# any single digit (0-9)
[list] any single character in the list
[!list] any single character not in the list
Hope that helps! You can also find more in Access' Help section (or in a
book like "Access 97 Bible", which is where I got the above info :).
Chris Montgomery [EMAIL PROTECTED]
Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner
210-490-3249/888-745-7603 Fax 210-490-4692
AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78
> -----Original Message-----
> From: paul smith [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 03, 2001 5:03 PM
> To: CF-Talk
> Subject: RE: Access97 Question
>
>
> Well, my client was trying to work it from the desktop.
>
> I've never been an Access buff and couldn't even figure out how
> to set LIKE
> '*foo*' from the desktop using query builder or whatever the hell Access
> calls it.
>
> best, paul
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
