Is it possible to concatenate two numeric fields, one with SMALLINT type and the other with INTEGER ?

DO you mean as in string concatenation?

i.e. 2 numbers 123 and 456 you want the result to be
123456?

You would have to do:
CHAR(MyNumericField1) || CHAR(MyNumericField2) As SomeField


fv