SQL function to trim all including char 160

The SQL standard functions provided in MsSQL LTrim() and RTrim() if used together should supposedly trim away both leading and trailing white spaces and tabs. However, it seems Char(160) is ignored from the triming "exercise".

The following custom function provides a fix to this annoying "bug".

CREATE FUNCTION TrimAll (@s VARCHAR(MAX))
RETURNS VARCHAR(MAX)
AS
BEGIN
    RETURN RTrim(LTrim(Replace(@s, Char(160), ' ')))
END
GO

To use, simply do something like this

SELECT dbo.TrimAll(MyField) FROM MyTable