Convert Help Please!

biznez · #1 (**permalink**) 01-27-12, 14:58

i have interest rates in format
0.0527500
0.0525000

i need something like this for eg:

Add leading zeroes(eg. 0.0527500 to be presented as 05275 and 0.0525000 to be presented as 05250)

thanks in advance for help

Pat Phelan · #2 (**permalink**) 01-27-12, 15:05

Formatting and presentation issues SHOULD be handled on the client, not within the database. You can do this, but you should not:

Code:

SELECT SubString(CAST(n AS VARCHAR), 3, 5)
   FROM (SELECT 0.0527500 AS n
      UNION ALL SELECT 0.0525000
      ) AS z

-PatP

biznez · #3 (**permalink**) 01-27-12, 15:33

thanks Pat

Internet Services

Web Development

Digital Marketing

Consumer Tech