The question assumes SET ANSI_NULLS ON Although it is ON by default, and will stay ON on later SQL version it's not always the case on older SQL...