Good question but it is a variation on a theme we've had as QOD in the past. I wish the Questioner would have included a few more details on Ansi NULL ON vs OFF.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum