I need help with converting a decimal field (Hours Worked) to a varchar field.
Required format:
2080.00 hrs. should be displayed as 208000
780.50 hrs. should be displayed as 078050
Other than a case statement that determines the lenght, I'm not sure how to make sure the leading zeroes are included.
Any help would be appreciated.
Thanks,
Jeff