Re: SQL
From: Brighton Health Care - I.T. <itdept_at_bhcnt.demon.co.uk>
Date: 1996/10/14
Message-ID: <01bbba2b$cdac45c0$a41b989e_at_bhcnt.demon.co.uk>#1/1
Date: 1996/10/14
Message-ID: <01bbba2b$cdac45c0$a41b989e_at_bhcnt.demon.co.uk>#1/1
Try
update table1 set col1='01'||col1
where col1 like '30%';
Hope this helps ..
JB PLANTIN <sp006_at_dial.oleane.com> wrote in article
<32625766.3561_at_dial.oleane.com>...
> I've got to update a column adding some characters.
>
> The query i tried is the following :
>
> >update table1 set col1=concat('01',col1)
> >where col1 like '30%';
>
> It doesn't work. So, if someone could tell me if there's something
> wrong ?
> I would appreciate.
>
Received on Mon Oct 14 1996 - 00:00:00 CEST