RE: [KCFusion] Commas in Query

2002-08-14 Thread cfhelp
That's what I meant and thank you that fixed it.   Rick   -Original Message- From: Ron Hornbaker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 10:25 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Commas in Query   Do you mean apostrophes? Just escape

RE: [KCFusion] Commas in Query

2002-08-14 Thread Ron Hornbaker
Do you mean apostrophes? Just escape them with an extra apostrophe, like so:    AND (Body LIKE '%Mr. Robert''s%')   -Ron -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of cfhelpSent: Wednesday, August 14, 2002 10:20 AMTo: [EMAIL PROTECTED]Sub