UFN_WEALTHPOINT_MC_FROM_FILERID
Return
| Return Type |
|---|
| nvarchar(3) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FILERID | nvarchar(20) | IN |
Definition
Copy
create function dbo.UFN_WEALTHPOINT_MC_FROM_FILERID(
@FILERID nvarchar(20) = null
)
returns nvarchar(3)
with execute as caller
as begin
declare @MC nvarchar(3)
select top 1 @MC = MC from WPSECURITIES
where FILERID = @FILERID
and MC <> ''
return coalesce(@MC,'')
end