@jeff

If im going to hard code it wouldn't it just be easier (i.e. not having to create a view) to go with the IF @State = 'AZ'...

Its hard coded to the extent that only my 3 tables listed will be able yo be altered.