Re: Inserting a ' in a VARCHAR

"Joe Patterson" <jpatterson_at_elitra.com> wrote in message news:jQx%4.400$N25.86337_at_news-west.eli.net...
> How does one include a ' (single quote, apostrphy) directly into a VARCHAR?
> Is there a way to escape the quote like \' or something? I want to avoid
> converting the ' to a work like prime or apostrophy.
>
> Anyone know how to do this?
>
> TIA,
> Joe

Use '''', for example:

select '''' from dual;

-Matt Received on Wed Jun 07 2000 - 00:00:00 CDT