[function] 숫자에 억,만 단위 붙이기

CREATE FUNCTION [dbo].[fn_MoneyToKor]

(

    @price    FLOAT

)

RETURNS NVARCHAR(500)

AS

BEGIN

DECLARE @salePrice FLOAT

DECLARE @deposit FLOAT

DECLARE @monthlyRent FLOAT

DECLARE @tempMoney1 FLOAT

DECLARE @tempMoney2 FLOAT

DECLARE @tempMoney NVARCHAR(500) = ''

SET @deposit = @price;

SET @monthlyRent = 100;

SET @tempMoney1 =  FLOOR(@deposit / 100000000)

SET @tempMoney2 =  FLOOR((@deposit - (@tempMoney1 * 100000000)) / 10000)

IF @tempMoney1 > 0 

SET @tempMoney = CONVERT(NVARCHAR(100), @tempMoney1) + '억'

IF @tempMoney2 > 0 

SET @tempMoney += CONVERT(NVARCHAR(100), @tempMoney2) + '만'

      

    RETURN @tempMoney

END

예)

SELECT dbo.fn_MoneyToKor('120000000') + '만'

result

1억2천만