Jeff all valid points. The ssn right now is last four and the plan is to go to a hashed number right now the table is in the proof of...

It sort of makes sense but not entirely. I'm not evaluating the phone numbers together but instead want to treat them two separate values

Does the ANI = "6141112222' or does...

changed the or to and

that did the trick! Sorry for the newb question but I'm new to this and trying to learn.

but there are two different instances where I do not want records to be written to the table.

when the ANI = '614xxxxxxx' or if the ANI = '614yyyyyyy'

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'...

Jeff no issues with Columbus just using that area code as the example.

Anyway I created the trigger suggested replacing my example data with the data that I want to actually...

apologies didn't realize you need the PK and types

There is a PK on DateTime(datetime), Script_Code(varcahr(4)) and ANI(varchar(15)

okay so the table in question has the following columns

DateTime

Acct_Number

SSN

Script_Code

Div_indicator

first_name

last_name

ani

terminate_area

transfer_area

Periodically we are getting records in this table where ani = 614xxxxxxx

We want to prevent all records with the ani =...