Help: Dynamic SQL simple question

I want to create a statement like the following, but how do I put the ' symbol around the variable "value" (because it is a text variable) ?!?!

EXECUTE IMMEDIATE 'UPDATE ' || table_name || ' SET ' || field_value || ' = ' || value || ' WHERE ' || id || ' = ' || p_id;

Thanks,

            Araxes Received on Sat May 26 2001 - 18:47:26 CDT