shaji_am
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
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