Not if he's using MX. Bug. ----- Original Message ----- From: "Jeff" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, March 13, 2003 2:24 PM Subject: Re: like %whatever% doesn't work in access?
> on 3/13/03 3:21 PM, Dina Hess at [EMAIL PROTECTED] wrote: > > > Really? > > > > I use that syntax with Access and don't have a problem: > > > > t.summary LIKE <CFQUERYPARAM CFSQLTYPE="CF_SQL_LONGVARCHAR" > > VALUE="%#form.txtsearch#%"> > > > > ~Dina > > You think maybe he should try wrapping it in a trim() function? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
