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
[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 '% M
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
