UFN_PDACCOUNTSTRUCTURE_GETSEPARATOR
Retrieves the separator character to use between segments in the accountnumber.
Return
| Return Type |
|---|
| nvarchar(1) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @Sequence | int | IN |
Definition
Copy
CREATE function dbo.UFN_PDACCOUNTSTRUCTURE_GETSEPARATOR(@Sequence int)
returns nvarchar(1)
as
begin
return (SELECT case SEPARATORCODE when 6 then '' else SEPARATOR end FROM PDACCOUNTSTRUCTURE WHERE SEQUENCE = @Sequence and PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B')
end