On 18/05/2012 21:30, J.V. wrote:
> update table set varcharid = ''' || tmp_var || '''
Others have answered your question, but there's a problem here too; you
don't need the quotes. This statement should be just:
update table set varcharid = tmp_var;
...assuming that the types match, of course.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie