I like the CHR() function because my tiny little brain can never remember how many ' I need to display ' (is it 2,3,4 or 42????) There is also an ASCII() function to return the ascii number of a character (sorry IBMers, there is not an EBCIDIC() function...) ;) Mladen Gogala wrote: > Or, using the double trouble quotes: > insert into t1 values('A''MHOINE PSAMMITE'); > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------