SQL

[owenyuen]

I have some data in my table declared in varchar
2000
200
20
2

Is any way I can write a SQL to output those data as

2000
0200
0020
0002

Many Thanks

 

[carp]

Take a look at the LPAD function.

 

[BJCooperIT]

If all data in the column is numeric:

select to_char(to_number(column_name),'099999') my_value
from   my_table
order by 1;

Good Luck!

select * from Life where Brain is not null

Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000
[sup]When posting code, please use TGML for readability. Thanks![sup]