> you could have a column with the value -b in the first SELECT... uh, wait a sec... b appears to be a date i would suggest you take another look, or explain what you're doing, because right now i don't think you need a UNION at all ;o)