Go to Solution.
No, there's no need to switch it to ON because it's the default in Teradata/Standard SQL.
If you ask for 'SET ANSI_NULL OFF', there's no way to get this :-)
No, Teradata always follows ANSI / ISO standard for comparisons with NULL.
There is no syntax to enable (or disable) this behavior.