Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

All

i have a problem with serial number format.
i have the serial numbers as 1,2,3 upto 'n'.
and i need to show this as roman letters(i,ii,iii,iv....).
i need to display this in crystal report.


thanks in advance....

share|improve this question

closed as not a real question by gbn, Mark Storey-Smith, Nick Chammas, JNK Jun 27 '12 at 2:15

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

4  
Google:simple-talk.com/sql/t-sql-programming/… –  gbn Jun 14 '12 at 9:43
    
Thanks for the response....i have this problem with crystal report and crystal report itself has one internal function to convert ROMAN(Serialrumber)...and my problem is now get solved.I Dont get it first and then i go for converting it at the query part itself..this is why i made this question...<br>Thank you for the response... –  Sivajith Jun 14 '12 at 10:00
    
Great link @gbn, that was a fascinating read. –  RThomas Jun 14 '12 at 16:08
    
@Sivajith Then you question is off-topic here. –  Marek Grzenkowicz Jun 20 '12 at 8:59