asked on

display values

Hi,

Is there any method to pad values in SQL server just like lpad and rpad in ORACLE.
I want to display the values right aligned and two fixed decimal places( if no decimal places .00 to be displayed)
My number optionally contains sign also

Thanks

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jgould

Hello Shaji_am,

you've got several open questions

https://www.experts-exchange.com/questions/20117472/Arraya-in-SQL-server.html
https://www.experts-exchange.com/questions/20117484/Communication-between-servers.html
https://www.experts-exchange.com/questions/20247782/Database-Restore.html
https://www.experts-exchange.com/questions/20340207/display-values.html
https://www.experts-exchange.com/questions/20105806/Creating-a-new-port-in-a-Local-machine.html

you have 3 options

-accept a comment as answer
-if already solved it state the solution and get a refund of your points
-otherwise if you want to delete the question, make it clear in the thread

IMPORTANT : Experts if you got any recomendation on clsoing the question let it be known too

your last login is of 6 november 2002 so you're still active here

i will come back in 7 days and will close the question accordingly

thanks
JGould-EE Moderator

twalgrave

shaji_am,

You have 8 opened questions as of this date.
I will be posting in each of these questions older than a month.
Please take care of your opened questions older than 30 days by clicking on your logon name link and looking for UnlockedQ or using the links I am providing below.
Please finalize these within 72 hours or I will ask administration to look into your account at that point.
If you have questions, please ask and I will provide assistance.

https://www.experts-exchange.com/questions/20340207/display-values.html
https://www.experts-exchange.com/questions/20247782/Database-Restore.html
https://www.experts-exchange.com/questions/20117484/Communication-between-servers.html
https://www.experts-exchange.com/questions/20117472/Arraya-in-SQL-server.html
https://www.experts-exchange.com/questions/20105806/Creating-a-new-port-in-a-Local-machine.html
https://www.experts-exchange.com/questions/20375340/Different-language-in-one-PDF-through-VB.html
https://www.experts-exchange.com/questions/20324261/Creating-a-PDF-file-in-a-VB-application.html

Thank you.