• I created this trigger

    CREATE TRIGGER TR_SomeTableInsteadOfFilter ON SomeTable

    INSTEAD OF INSERT

    AS

    BEGIN

    SET NOCOUNT ON;

    INSERT INTO SomeTable([DateTime],Acct_Number,SSN,Script_Code,Div_indicator,first_name,last_name,ani,terminate_area,transfer_area)

    SELECT [DateTime],Acct_Number,SSN,Script_Code,Div_indicator,first_name,last_name,ani,terminate_area,transfer_area

    FROM INSERTED WHERE ani <> '614xxxxxxx' or ani <> '614yyyyyyy';

    END

    I am still able to insert records with the ani = '614xxxxxxx' or ani = '614yyyyyyy;