CREATE FUNCTION [dbo].[fn_RemoveSpecialCharacters] (@name VARCHAR(max))
RETURNS NVARCHAR(max)
AS
BEGIN
DECLARE @str VARCHAR(MAx)
SET @str
= @name
WHILE PATINDEX('%[
!@#$%^&*()<>?:"{},./;=+|\_]%',
@str) > 0
SET @str = REPLACE(@str, SUBSTRING(@str, PATINDEX('%[ !@#$%^&*()<>?:"{},./;=+|\_]%', @str), 1), '')
RETURN replace(@str, '-', '')
END
No comments:
Post a Comment