On Thu, 14 Apr 2016 20:10:08 -0400
"Keith Medcalf" <kmedcalf at dessus.com> wrote:
> select <stuff> from <tables> where isActive;
vs.
> select <stuff> from <tables> where isActive = 'T';
AFAIK, the SQL standard requires the second form. You can't simply say
"WHERE variable"; you must say "WHERE expression".
OP: I personally usually use the T/F or Y/N versions over 1/0 because my
interactive query results are just a little easier to interpret. Use
what you like, because size and performance differences are likely to
be negligible.
--jkl
