Re: [Emerald] Nulls in MBR Taxable?

Dale E. Reed Jr. ( (no email) )
Fri, 22 Jan 1999 10:06:30 -0800

John Troher wrote:
>
> 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

I don't think it will matter. As long as its not 1, they MBR is
not taxable. For systems that were upgraded, the accounts will
most likely have a NULL taxable field, which Emerlad interprets
at 0.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

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