>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
