on 3/13/03 2:48 PM, Smith, Matthew P -CONT(DYN) at [EMAIL PROTECTED] 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, In fact, on page 7-9 it says the following: "Two SQL Wildcards exist. The percent sign (%) is a placeholder for zero or more characters. The underscore character (_) is a placeholder for exactly one character." Like I said, I just went thru the class last week, and every example we created was done using Access. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
