https://mssqlfun.com/2012/08/27/new-built-in-logical-functions-in-sql-server-2012-part-4-of-5/