UFN_PROGRAMEVENTREGISTRATIONSECTION_PREFIXSECTIONINLINE
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEQUENCE | int | IN | |
| @SECTIONDESCRIPTION | nvarchar(100) | IN |
Definition
Copy
create function dbo.UFN_PROGRAMEVENTREGISTRATIONSECTION_PREFIXSECTIONINLINE (
@SEQUENCE int,
@SECTIONDESCRIPTION nvarchar(100)
)
returns table
as return
select cast(case when @SEQUENCE < 10 then '0' else '' end
+ convert(nvarchar(max), @SEQUENCE) + '. '
+ @SECTIONDESCRIPTION as nvarchar(150)) as PREFIXDESCRIPTION;