Display Currency as char(14) with leading zeros + no decimal point

Hi All

I'm converting some Access VBA to T-SQL where I take a Currency value, remove the decimal, and feed it as a char(14) with leading zeros.

Access:  Format(Round(1234567.89*100),"00000000000000") will return 00000123456789

What is the SQL equivalent of this?

TIA
Jim

Start Free Trial