SDU Tools: Number to Roman Numerals in SQL Server

Ever since we've been shipping our free SDU Tools for developers and DBAs, we've been getting interesting requests from users for additions to the tools. Today's tool is one of the stranger requests but for the odd situation where you need it, I'm sure we will have saved you a lot of work. That tool is NumberToRomanNumerals.

The person who requested it was outputting values that need to go into media trailers, pretty much as you see Roman numerals in the tail end of many movies.

So we added a simple function. It takes a single parameter which is the number that you want to convert, and it outputs the Roman numerals as a string. I'm sure the Romans weren't really thinking about big numbers but we made it capable of dealing with quite large numbers.

You can see it executed in the main image above, and you can see it in action here:

To become an SDU Insider and to get our free tools and eBooks, please just visit here:

http://sdutools.sqldownunder.com

Leave a Reply

Your email address will not be published.