Login     Register

        Contact Us     Search

XLeratorDB/math Documentation

SQL Server ROMAN function


ROMAN
 
Updated: 17 August 2010
Use ROMAN to convert an arabic numeral to a roman numeral, as text.
Syntax
SELECT [westclintech].[wct].[ROMAN] (
   <@Number, float,>)
Arguments
@Number
is the number to be converted. @Number is an expression of type float or of a type that can be implicitly converted to float
 
Return Types
nvarchar
Remarks
·         @Number will be truncated to an integer
·         If @Number is negative, an error will be returned
·         If @Number is greater than 3999, an error will be returned
Example
 
SELECT wct.ROMAN(2008)
Here is the result set
----------------------
MMVIII
 
(1 row(s) affected)


Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service