If my statement only has the where A<>B it works, however, if I place a nestled (A<>B or A<>C) it ignores the both restrictions. I cannot seem to figure out how to do this in a single select.
SELECT * FROM Table x
WHERE Z = 'value'
and Y = 'value'
AND ( (A<>B) or (A<>isnull(C,0)) )
and T='value'
SELECT * FROM Table x
WHERE Z = 'value'
and Y = 'value'
AND ( (A<>B) or (A<>isnull(C,0)) )
and T='value'