Interesting topic, yet confusing at times when determining times to set the ANSI_NULL to ON or OFF to yield expected results. Thanks.