I wouldn't really call documented behaviour a twist, but maybe it is good to remind people once in a while that there are such caveat's, especially when working with NULL values.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP