Hi,

I have a value at number and need to convert this number to char, there are some statement or function for this.

thank you for you hep.

greetings

try this:
select concat('',yourcolumn) ...

then you can put further string functions around it:
select substr(concat('',yourcolumn),1,3) as youraliasname ...

Thank you for you help,

You can tell me the systax it completes.

thank you.

Georgipa,

From IDS 9.x up you can use the builtin cast functionality, like integer::char(x) or CAST(integer AS char(x)). Thus you can use string functions around it like:
Works more straightforward than concatenation or other functions...

BTW. If you're talking about Informix 4GL: implicit casts are done by assigning a numeric value to a character variable so nothing special has to be done.

Regards