<table border='1' cellpadding='10' cellspacing='0'> <tr><th>Expression<th>Logically equivalent to <tr><td>'1xxx' == TRUE<td>'1xxx' == 1 <tr><td>'1xxx' IS TRUE<td>CASE WHEN '1xxx' THEN 1 ELSE 0 END </table>
<table border='1' cellpadding='10' cellspacing='0'> <tr><th>Expression<th>Logically equivalent to <tr><td>'1xxx' == TRUE<td>'1xxx' == 1 <tr><td>'1xxx' IS TRUE<td>CASE WHEN '1xxx' THEN 1 ELSE 0 END </table>