Thank you, that worked. thanks everyone for your help on this.

Here is my revised SQL statement. Still not working but I thought I would post it and maybe someone can spot what I am doing wrong

SELECT table1.column1, table2.column1 as SomeRandomColumnName,...

I like the idea about using a separate column to use for computing the bit value, but still I am not sure how to implement this. Main question is if...

I have been trying that ISNULL logic, which is what I had in my Access DB Query which basically checks if there is a null value and places a zero...

Thanks, I figured it would be a trigger. I could just not find an example that is similar. Mine will evaluate another table's column field and then create a boolean...