| Author's name: Michael Eichler Author's Email:meichler@proteus.com |
Date written: 4th March 2002 Oracle version(s): 8.1 |
| How do I embed single-quote marks in an SQL statement | |
Simply escape it with another single-quote. For example, try
SELECT 'New Year''s Day' FROM dual;
and you will get the text formatted appropriately, including the single quote..
Further reading: See also "How do I I insert an apostrophe (') into a column using simple SQL "