Re: Insert an apostrophe into a string?

Martin Pammer wrote:
>
> Use the SQL Function chr() for this.
>
> chr(10) gives you a newline
> chr(39) gives you an apostrophe
>

You can use two tick marks. For example,

   SELECT '''' from dual;
would return a single tick mark. It is exactly like

   SELECT 'X' from dual;
except that the X has been replaced by ''.

• Guy Bassan
• Los Alamos National Laboratories