>I need to use the union all sql statement, but I have 2 different numeric fields which are (19,2) and (20,2).
>
>How to query if I need to union these two fields?

SELECT VAL(STR(FIELD1,20,2)) AS NEWFIELD FROM ..
UNION
SELECT VAL(STR(FIELD2,20,2)) AS NEWFIELD FROM ..