How to concatenate two fields into one in progress SQL?

Help please!

Could anyone advise me how to concatenate two fields into one in progress SQL?
My SQL statement is as follows:

select pub.tableA.fieldA || pub.tableA.fieldB from pub.tableA

pub.tableA.fieldA is character type
pub.tableA.fieldB is integer type

Of course this SQL statement doesnot work since the data type of fieldA and
fieldB are different .

Could anyone advise me?

Christine

--
Webmail