Re: NULLs

On 27 Apr 97 at 11:46, Edward A. Sarog wrote: > Correct but there should be no unknown data in the database. > i.e. if you don't know then find out before trying to enter it into > MY database. :-> > > I've heard the argument that if you allow nulls then you're design > is flawed.... Well, now: in the main, I agree, but it is often the case that you don't know the full particulars at the time the record is captured. Nulls then allow you to highlight missing data in a consistent and efficient manner. -- Ciao, Billy Nose to the ground and ear to the grindstone in: Johannesburg "...but apart from that, Mrs Kennedy, how was the parade?"