Re: Convert Char to Num

}>From ilist@rmy.emory.edu Mon Aug 11 10:33:12 1997 }>Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4]) }> by hobbes.dbintellect.com (8.8.6/8.8.6) with ESMTP id KAA15967 }> for <settler@dbintellect.com>; Mon, 11 Aug 1997 10:33:11 -0600 (MDT) }>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id KAA20453 for informix-list-out; Mon, 11 Aug 1997 10:15:01 -0400 (EDT) }>From: "Damien" <damien_chambe@cornut.fr> }>Message-Id: <01bca658$9b6bd700$44cd09c0@dam> }>Subject: Convert Char to Num }>Date: 11 Aug 1997 13:20:20 GMT }>Reply-To: "Damien" <damien_chambe@cornut.fr> }>Organization: CORNUT Informatique }>Sender: informix-list-owner@rmy.emory.edu }>To: informix-list@rmy.emory.edu }>X-Informix-List-Id: <news.41488> }> }> }>Is there a function to convert a CHAR to a Numeric format ? }>I want to make a SUM from a column wich contains some numeric data, }>but the type of the column is CHAR and I can't change it. }> }>Thanks. }> The only way I know of is to write a stored procedure that accepts a CHARACTER argument as input and returns an INTEGER argument. ------------------------------------------------------------------- Jeff Craig | dbINTELLECT Technologies, Inc. Senior Consultant | Golden, CO | (303) 275-6954 ext. 8008 | email: settler@dbintellect.com | fax: (303) 275-2134 -------------------------------------------------------------------