how to acieve this value in sql server

Posted by Jayakumars under ASP.NET on 9/29/2011 | Points: 10 | Views : 852 | Status : [Member] [MVP] | Replies : 1
Hi

I have attach jpg file below then i am marked yellow mark i need only roman
letters only need like class

i need output only refer below image
==========
I
II
III
IV
V

Mark as Answer if its helpful to you


Responses

Posted by: Vuyiswamb on: 9/29/2011 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
Look at this

http://www.simple-talk.com/sql/t-sql-programming/numeral-systems-and-numbers-conversion-in-sql/

http://www.sqlservercentral.com/blogs/philfactor/archive/2011/09/20/roman-numerals-to-integers-and-vice-versa-in-sql.aspx

Thank you for posting at Dotnetfunda

Thank you for posting at Dotnetfunda
[Administrator]

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response