UFN_WPMATCHCODE_DESCRIPTION
Returns the description of a Prospect Wealth match code.
Return
| Return Type |
|---|
| nvarchar(100) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MATCHCODE | nvarchar(4) | IN |
Definition
Copy
CREATE function dbo.UFN_WPMATCHCODE_DESCRIPTION(@MATCHCODE nvarchar(4))
returns nvarchar(100)
as
begin
declare @DESCRIPTION nvarchar(100);
select
@DESCRIPTION= DESCRIPTION
from
dbo.MATCHCODE
where
MATCHCODE = @MATCHCODE
return @DESCRIPTION
end;