Matthew, The wild card in Access is the asterisk, so instead of:
WHERE tbl.field LIKE '%#form.criteria#%' Use WHERE tbl.field LIKE '*#form.criteria#*' Susan Kennedy Tallahassee, FL -----Original Message----- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 2:49 PM To: SQL Subject: like %whatever% doesn't work in access? WHERE tbl.field LIKE '%#form.criteria#%' Does this syntax not work in access? I get 0 records no matter what. It's for a search. Thanks for any help, Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
