Sorry about that, I modified the SQL just removing the foreign key, you don't need it for the purpose of this query.

I created some test tables and data and I found my SQL wasn't giving me what I wanted.

UB_MASTER_TEST TABLE

CREATE TABLE dbo.ub_master_test (

ub_master_id int NOT NULL,

ub_batch_sub_number int...

Thank you for all the ideas though, this website is awesome. I am not sure whether to select any as an answer since it didn't really answer my particular...

I am still trying to figure out the best way to do this. The problem with a function is that I don't know the values to pass into a...

Thank you for your answers. I personally did not think there was a way to do it, but I did want to get others input as sometimes I can...

But how would do a BETWEEN 1 AND 5

OR (Field1,Field2,Field3,Field4,Field5) > 10?