var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: number to char
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.
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.
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.