>Select * from Personal where Name like '%O'hara%';
>

Select * from Personal where Name like '%O''hara%';

Double quotes (that is, two single quotes) will escape the single quote.

-dhs
--
Dean H. Saxe  --  I hate misanthropes.  --  [EMAIL PROTECTED]
Windows 95: n.   32 bit extensions and a graphical shell for a
16 bit patch to an 8 bit operating system originally coded for a
4 bit microprocessor, written by a 2 bit company, that can't
stand 1 bit of competition.

===========================================================================
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

Reply via email to