> -----Original Message----- > From: Susan Kennedy [mailto:[EMAIL PROTECTED] > 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#*'
Hello Susan, is this true only for LIKE comparison involving a form variable or perhaps only for certain versions of Access? We use the % wild card with CF and Access 2000 with no problems. Charles --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.461 / Virus Database: 260 - Release Date: 3/10/2003 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
