GO
CREATE  FUNCTION dbo.IF_CleanWithReplace
        (
        @SomeText VARCHAR(100)
        )
RETURNS TABLE
WITH    SCHEMABINDING
AS      RETURN
        SELECT  cleaned = 
                    REPLACE(
                        REPLACE(
                            REPLACE(
                                @SomeText COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS,
                                'A', SPACE(0)),
                            'E', SPACE(0)),
                        '-', SPACE(0));
GO