Re: SQL

Try

UPDATE table1
SET col1='01'||col1
WHERE col1 LIKE '30%';

I don't think there is a concat command in SQLPlus

Hope this helps

Matt

mmarrow_at_pacbell.mobile.com

JB PLANTIN (sp006_at_dial.oleane.com) wrote: : 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.