> SELECT 0000.00 as price,code,otherfield from... > union; > SELECT price, code ,space(10) as otherfield.. And if you've got some calculations to do, you can: select val(str(sum(field),10,2)) as total from etc. to ensure that the numeric sizes are the same. I was quite pleased to find that this works in 2.6, and I hope they haven't busted it in 3 or 5.