Preceding Zero - Urgent Help Need

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi guys,

I have a query to retrieve data from sales table which
has data like the following:

ID Amount
1 52.50
2 100.00
3 1000.00

I want to change the format to the following:

ID Amount
1 005250
2 010000
3 100000

Does anyone have a idea?

Any help will be appreciated.

Thanks in advance.

Tim.
 
Back
Top