Re: Insert single quote

apart from '''', you can also use
chr(39) <--- 39 is the ascii value for single quote.

try select 'It'||chr(39)||'s easy to do!' from dual;

hope it helps.

s_c_99_at_hotmail.com

Marty Provost wrote:
>
> Stupid question...
>
> What's the syntax to insert a string that contains a single quote?
>
> Example:
>
> TABLENAME
> columnname varchar2(100)
>
> insert into tablename (columname)
> values ('help me insert this ' into this column');
>
> Thanks in advance,
> Marty
  Received on Wed Apr 19 2000 - 00:00:00 CDT