UFN_FAFEVENT_VALIDEVENTURL
Return
| Return Type |
|---|
| nvarchar(1024) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTURL | nvarchar(1024) | IN |
Definition
Copy
create function dbo.UFN_FAFEVENT_VALIDEVENTURL
(
@EVENTURL nvarchar(1024) = null
)
returns nvarchar(1024)
with execute as caller
as begin
declare @ind int
declare @char nvarchar(10)
while patindex('%[^0-9a-zA-Z_-]%',@EVENTURL) <> 0
begin
set @ind = patindex('%[^0-9a-zA-Z_-]%',@EVENTURL)
set @char = substring(@EVENTURL,@ind,1)
set @EVENTURL = REPLACE(@EVENTURL,@char,'')
end
return @EVENTURL
end