How to convert numbers to roman numerals in SQL Server

Views: 889
Reading Time: <1 minute

Hello everybody!
Good Morning!

In this post I will demonstrate how to convert a normal (base 10) number to a Roman numeral (X, XVII, etc.) using a Transact-SQL function in SQL Server that I found in the blog of Advaldo Paiva. Because it is a function, we can apply it for a simple conversion or for updating table data, for example.

Function Code:

Usage examples:
SQL Server - Roman Numbers Roman Numeral

That's it guys,
Thanks for stopping by and see you next time!

How to convert numbers to roman numerals in SQL Server Romain Numeral

How to convert numbers to roman numerals in SQL Server Romain Numeral