Re: string quote problem

You could try using the escape character. For instance:

vitem := '\'1000010\''

(two single quotes at the end)

HTH,
George

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.
Received on Wed Sep 27 2000 - 11:38:26 CDT