UFN_BANKACCOUNT_GETMASKEDACCOUNTNUMBER

Return

Return Type
nvarchar(50)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_BANKACCOUNT_GETMASKEDACCOUNTNUMBER
(
    @ID uniqueidentifier
) 
returns nvarchar(50) 
as
begin
  declare @ACCOUNTNUM nvarchar(50);
    declare @MASKEDACCOUNTNUMBER nvarchar(50);

    select     @ACCOUNTNUM = dbo.UFN_BANKACCOUNT_GETACCOUNTNUMBER(BANKACCOUNT.ID),
          @MASKEDACCOUNTNUMBER = case when len(@ACCOUNTNUM) = 0 then ''  
            else REPLICATE('x', LEN(@ACCOUNTNUM)- LEN(RIGHT(@ACCOUNTNUM,4))) + RIGHT(@ACCOUNTNUM,4) end
  from dbo.BANKACCOUNT
  where ID = @ID;

    return @MASKEDACCOUNTNUMBER;
end