ROMAN

Updated 2023-10-20 15:56:36.093000

Syntax

SELECT [westclintech].[wct].[ROMAN] (
   <@Number, float,>)

Description

Use the scalar function ROMAN to convert an Arabic numeral to a Roman numeral, as text.

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 Type

nvarchar(4000)

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.

Examples

SELECT wct.ROMAN(2008);

Here is the result set.

{"columns":[{"field":"column 1"}],"rows":[{"column 1":"MMVIII"}]}