[Emerald] Nulls in MBR Taxable?

John Troher ( admin@isoc.net )
Fri, 22 Jan 1999 09:44:44 -0500


Looking through my masteraccounts table I found that all
MBR's that are taxable a marked taxable = 1 But I see
very few of the others that are marked taxable = 0, most
are NULL

My question is should it be either 0 or 1 and no nulls?

can I do something like:

ALTER Table MasterAccounts
SET Taxable = 0
WHERE Taxable = NULL

John Troher

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html