try entering a single quote twice (not a double quote!)
'%O''hara%';
Andy
----- Original Message -----
From: Dominic Choo <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 24, 2000 03:13
Subject: Database Help
> I would like to ask anyone the help me to solve this SQL command problem.
> For example:
>
> Select * from Personal where Name like '%O'hara%';
>
> This SQL command will produce an error because the existance of the " ' "
> character in the "O'hara" word.
> Please help me to solve this problem...... Thanx!
>
>
> Choo Khai Shien, Dominic
>
>
>
>
>
>
>
> ---
> Disclaimer note:
> Confidential information may be contained in the e-mail and any files
> transmitted with it ('Message'). If you are not the addressee indicated in
> this Message (or responsible for the delivery of this Message to such
> person), you are hereby notified that any dissemination, distribution,
> printing or copying of this Message or any part thereof is strictly
> prohibited. In such a case, you should delete this Message immediately and
> advise the sender by return e-mail. Opinions, conclusions and other
> information in this Message that do not relate to the official business of
> e-BX nor any of its related companies shall be understood as neither given
> nor endorsed by e-BX nor any of its related companies.
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
