Re: string quote problem

Hi,

  You could also try chr(39) to get the quote inserted wherever u   want...

Regards

In article <8qtaec$7sl$1_at_nnrp1.deja.com>,   christianboivin1_at_my-deja.com wrote:
> you can do this
>
> strsel := 'select * from sales where item = ''' || v_item || ''';';
> put two quotes when you want one
> in your string
>
> Chris
>
> In article <8qt484$22t$1_at_nnrp1.deja.com>,
> terry_stjean_at_my-deja.com wrote:
> > I am building a string in PL/SQL.
> > I want it to look as follows:
> >
> > select * from sales where item = '1000010';
> >
> > I have the following:
> > strsel := 'select * from sales where item = ' || v_item || ';';
> >
> > v_item is a character variable used in the string.
> > How do I get the single quotes around the value of v_item?
> >
> > Terry
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Regards
Rajagopal Venkataramany


Sent via Deja.com http://www.deja.com/
Before you buy.