Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> question about set statement

question about set statement

From: jAnO! <j.j.groot_at_kpn.com>
Date: 23 Aug 2001 11:20:49 GMT
Message-ID: <01c12bc5$a95869e0$532b15ac@TONTW0108082044>


Hi all,

I have a column in my table that is poluted by users. It is a 3 position varchar column.
The values must be 001 002 003 etc. But now i have values like "1 ". I want to convert this data to the right format, and tried this:

set ASN_PULS_CODE = TO_CHAR(ASN_PULS_CODE,'000')

didn't work..

i also tried this:

set ASN_PULS_CODE = lpad(ASN_PULS_CODE, 0)

both didn't work... can anybody help me out???

thanks,

Jan Received on Thu Aug 23 2001 - 06:20:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US