string quote problem

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 - 10:37:40 CDT