IF  EXISTS (SELECT * FROM sys.objects  
			WHERE object_id = OBJECT_ID(N'[dbo].[fn_QBRemoveNonAlphaChars]')  
            AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[fn_QBRemoveNonAlphaChars]
GO
      
CREATE FUNCTION [dbo].[fn_QBRemoveNonAlphaChars](@String VARCHAR(1000)) 
RETURNS VARCHAR(1000) 
AS 
BEGIN 
 
    WHILE PATINDEX('%[^a-z ''^-]%', @String) > 0 
        SET @String = STUFF(@String, PATINDEX('%[^a-z ''^-]%', @String), 1, '') 
 
    RETURN @String
END
GO

select dbo.[fn_QBRemoveNonAlphaChars]('The~@ CA:$%&*$()T -   SA0099878778747T ~~~;;;!||o*&")|n the ma@@@@@t')

select dbo.[fn_QBRemoveNonAlphaChars]('The^~@ CA:$%&*$()T -   SA0099878778747T ~~~;;;!||o*&")|n the ma@@@@@t')

RETURN @String

RETURN REPLACE(@String, '^','')

CREATE FUNCTION [dbo].[fn_QBRemoveNonAlphaChars] (@String VARCHAR(1000))
RETURNS VARCHAR(1000)
AS
BEGIN
	WHILE PATINDEX('%[^a-z ''-]%', @String) > 0
		SET @String = STUFF(@String, PATINDEX('%[^a-z ''-]%', @String), 1, '')

	RETURN @String
END

IF EXISTS (
		SELECT *
		FROM sys.objects
		WHERE object_id = OBJECT_ID(N'[dbo].[fn_QBRemoveNonAlphaChars]')
			AND type IN (N'FN', N'IF', N'TF', N'FS', N'FT')
		)
	DROP FUNCTION [dbo].[fn_QBRemoveNonAlphaChars]
GO

CREATE FUNCTION [dbo].[fn_QBRemoveNonAlphaChars] (@String VARCHAR(1000))
RETURNS VARCHAR(1000)
AS
BEGIN
	WHILE PATINDEX('%[^a-z ''^-]%', @String) > 0
		SET @String = STUFF(@String, PATINDEX('%[^a-z ''^-]%', @String), 1, '')

	RETURN @String
END
GO

SELECT dbo.[fn_QBRemoveNonAlphaChars](
		'The^~@ CA:$%&*$()T -   SA0099878778747T ~~~;;;!||o*&")|n the ma@@@@@t')

----------------------------
The^ CAT -   SAT on the mat

IF EXISTS (
		SELECT *
		FROM sys.objects
		WHERE object_id = OBJECT_ID(N'[dbo].[fn_QBRemoveNonAlphaChars]')
			AND type IN (N'FN', N'IF', N'TF', N'FS', N'FT')
		)
	DROP FUNCTION [dbo].[fn_QBRemoveNonAlphaChars]
GO

CREATE FUNCTION [dbo].[fn_QBRemoveNonAlphaChars] (@String VARCHAR(1000))
RETURNS VARCHAR(1000)
AS
BEGIN
	WHILE PATINDEX('%[^a-z ''-]%', @String) > 0
		SET @String = STUFF(@String, PATINDEX('%[^a-z ''-]%', @String), 1, '')

	RETURN @String
END
GO

SELECT dbo.[fn_QBRemoveNonAlphaChars](
		'The^~@ CA:$%&*$()T -   SA0099878778747T ~~~;;;!||o*&")|n the ma@@@@@t')

---------------------------
The CAT -   SAT on the mat

SELECT dbo.[fn_QBRemoveNonAlphaChars](
'ÀAlbèert ËEîinstêeiìn ÌInstìitúutëe - MPG')