• The question has been edited to include ANSI NULLS set on.