format data in stored procedure

I want to format data value like : let char_var = date_var using 'yy' ; ( get the year from date ) & let char_var2 = char_var1, int_var using '&&&&' ; (concatenate character and integer) These command working in 4gl program. How can I do the same job in stored procedure ?

On Thu, Aug 16, 2012 at 4:04 AM, joe <joeclhua@gmail.com> wrote: > I want to format data value like : > let char_var = date_var using 'yy' ; ( get the year from date ) > LET var_char = MOD(YEAR(date_var), 100); Beware the decade 00-09... LET var_char = YEAR(date_var); LET var_char = var_char[3,4]; Beware the millennium 0001..0999. > & > let char_var2 = char_var1, int_var using '&&&&' ; > (concatenate character and integer) > Once more, zero-fill for the '&&&&' is the tricky bit: LET char_var2 = 10000 + int_var; LET char_var2 = char_var1 || char_var[2,5]; These command working in 4gl program. > SPL != I4GL. > How can I do the same job in stored procedure? > -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused."