Kareem Badr wrote: > I should mention that free_space and size are defined as varchars, for > some reason. Not sure if that has anything to do with the issues I'm > seeing. > Do any of these fields contain NULL? as that will definately have an impact upon both joins and upon calculations. (when using a numeric field, it's always better to set the field NOT NULL, and default it to 0).
-- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113 Tel + 61 7 3219 9906 (x137) Fax + 61 7 3219 9938 mobile: 0423 532 733