Oninit cdi / Archive
Talk to an expert →

convert stringfield to integerfield from an INFORMIX DATABASE

Posted in 2004

Topics: General Discussion

↪ replying to Filip Arents
Art S. Kagel — — source: Usenet: comp.databases.informix

On Wed, 04 Aug 2004 17:25:58 -0400, Filip Arents wrote: > I would like to convert a numeric-field into a new "string"field. 1. what is > the correct operator for this conversion in an sql-statement? 2. where can I > find a good manual for sql on informix-databases ? ALTER TABLE mytable MODIFY (formerly_integer_column CHAR(20) ... ); The manuals are online at: http://www-306.ibm.com/software/data/informix/pubs/library/ Then select your server version and locate the manual you need. In this case it would be the 'Guide to SQL: Syntax'. Art S. Kagel

Filip Arents — — source: Usenet: comp.databases.informix

I would like to convert a numeric-field into a new "string"field. 1. what is the correct operator for this conversion in an sql-statement? 2. where can I find a good manual for sql on informix-databases ?

Related threads