Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> question about set statement
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