I am using Informix SE.
I have defined iBatchno INTEGER and strBatch CHAR(6) variables
I can SELECT INTO iBatchno FROM table
Now i need to make a string of format : "ABC" || iBatchno
I can not CAST(iBatchno AS CHAR(6))
I also can not LET strBatch = "ABC" || iBatchno
How do I cast an INT to a CHAR, and how do I concat 2 strings into a
varaible?
I have defined iBatchno INTEGER and strBatch CHAR(6) variables
I can SELECT INTO iBatchno FROM table
Now i need to make a string of format : "ABC" || iBatchno
I can not CAST(iBatchno AS CHAR(6))
I also can not LET strBatch = "ABC" || iBatchno
How do I cast an INT to a CHAR, and how do I concat 2 strings into a
varaible?