Re: I hate this

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 01 Nov 2002 22:20:07 +0100
Message-ID: <isr5sucmog8od5gsdbh04n81mafndqr5im@4ax.com>

On Fri, 1 Nov 2002 15:18:58 -0500, "bgt0990" <btighe_at_neometrics.com> wrote:

update bgt.bgt2 a
set a.labno =

     (select '19'||trim(b.labno) 
     from bgt.bgt2 b
     where  b.labno = a.labno

    )
where length(trim(a.labno)) = 9

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Nov 01 2002 - 15:20:07 CST