UFN_ENCRYPTEDROUTINGNUMBERISVALID
This function returns true if the encrypted routing number passed in is valid.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ROUTINGNUMBER | nvarchar(4000) | IN |
Definition
Copy
CREATE function dbo.UFN_ENCRYPTEDROUTINGNUMBERISVALID(@ROUTINGNUMBER nvarchar(4000))
returns bit
with execute as caller
as begin
--symmetric key must be opened before calling this function; it cannot be opened/closed within the function itself
return dbo.UFN_FINANCIALINSTITUTION_ROUTINGNUMBERISVALID(coalesce(convert(nvarchar(9), DecryptByKey(@ROUTINGNUMBER)),''))
end