WHERE tbl.field LIKE '*#form.criteria#*' Asterisk, not percent. Microsoft is not about to make it easy.
At 01:48 PM 3/13/2003 -0600, you wrote: >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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
