Re: Inserting a ' in a VARCHAR

From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: 2000/06/07
Message-ID: <sju5o2rd2t5177_at_corp.supernews.com>#1/1


"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 CEST

Original text of this message