RE: [KCFusion] Commas in Query

[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 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 cfhelp Sent: Wednesday, August 14, 2002 10:20 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Commas in Query I am sure this has been asked before.   What do I do about commas in a search?   I have a search field and someone searches for Mr. Robert's the comma error the SQL statement.   AND (Body LIKE '% Mr. Robert's %' OR Subject LIKE '% Mr. Robert's %')   Rick