SQL informix : How to join 2 fields in <> format:string with smallint?

[Alexandre01]

I have to join 2 fields in a select query with 2 differents format : string (valchar) and smallint ?

How can I manage it ?

I want to use the result field as a smallint .

 

[vpshriyan]

create temp table x (x1 char, x2 varchar(2));
insert into x values ('A','5');

create temp table y (y1 char, y2 smallint);
insert into y values ('A', 3);

--joining 2 fields
select trim(x2)||y2 from x,y where x1=y1;
--adding 2 fields
select trim(x2)+y2 from x,y where x1=y1;