Re: How to convert Integer to ASCII

Mark Would this work? ' '||MONTH(CURRENT)||YEAR(CURRENT) Not familiar with the SUBSTRING function in the form you are using, but since you are not getting errors on this, its probably supported...I use... SUBSTRING(exprtext,48, 5), instead of SUBSTRING(exprtext FROM 48 for 5), HTH Sujit mark.baumgartner@cardhealth.com on 08/23/2000 12:35:34 PM To: "'informix-list@iiug.org'" <informix-list@iiug.org> cc: Subject: How to convert Integer to ASCII Anyone know how to convert and integer value to character (without call a C program)? In a stored procedure the below query is failing with "-1213 A character to numeric conversion process failed." on the MonthYear variable. SELECT SUBSTRING(exprtext FROM 19 for 5), SUBSTRING(exprtext FROM 48 for 5), dbspace, SUBSTRING(dbspace FROM 1 for 4), MONTH(CURRENT)||YEAR(CURRENT), CASE WHEN MONTH(CURRENT) IN (1,3,5,7,8,10,12) THEN "31" WHEN MONTH(CURRENT) IN (4,6,9,11) THEN "30" ELSE "29" END INTO LessThanDateInt, --INT GreaterThanDateInt, --INT DBSpaceName, --CHAR DBSpaceDevice, --INT MonthYear, --CHAR DaysInMonth --CHAR FROM sales_tran_frags Where DATE(TRUNC(SUBSTRING(exprtext FROM 19 for 5))) in ( select MIN(DATE(TRUNC(SUBSTRING(exprtext FROM 19 for 5)))) from sales_tran_frags ); Thanks for any help. Mark