hello,

I have several columns in a table with number datatype.for eg : select a||' '||b from tablename
However, when i concatenate some of the columns with number datatype
and use reports 6i, and when i click the properties of the field in the layout editor, the datatype is varchar2. why is this?

if i dont concatenate, then the property in layout editor for those are number.

what is the problem.

Thanks