Padding? 1

[KizMar]

Problem:

I have a column that's a float (currency), so I could have "110.01" or "1.2" or "12" in the fields.

I need this field to show as 11 characters set. Ex. "00000123456" - where the last two digits are the cents.

I have the front of the string padded, but can't figure out how to take out any "." that exist and add "0" where needed.

Help?

 

[sunila7]

Hi,

Try this

select replicate('0',11-len(reverse(reverse(fldname*100)))) + reverse(reverse(fldname*100)) from tbl


Hope it helps
Sunil