Perhaps you want "IS TRUE" instead of "==TRUE".
~~~~~
SELECT '1xxx' IS TRUE, '1xxx' == TRUE;
~~~~~
Returns two columns with values 1 and 0.
Perhaps you want "IS TRUE" instead of "==TRUE".
~~~~~
SELECT '1xxx' IS TRUE, '1xxx' == TRUE;
~~~~~
Returns two columns with values 1 and 0.