Character to Numeric Conversion

Posted in 2000

Pietje Puk — Fri, 3 Nov 2000 11:06:33 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi, I want to convert a character field to numeric. For Micrsoft or Sybase SQL server v6.5 the select statement is: Convert(char,Tablename.Customer_ID) Does Informix have something like that? Thanks in advance Alex

↪ replying to Pietje Puk

Sergey E. Volkov — Fri, 3 Nov 2000 13:59:43 +0300 — source: Informix-list mailing list archive (1991-1998)

Depends on version of IDS. For example for IDS-9.x tablename.customer_id::char(10) -- ala c++ In earlier versions of IDS this isn't supported. Pietje Puk <Pietje@puk.com> ''''' ' ''''''''':3a028dde$0$25544@news2.zeelandnet.nl... > Hi, > > I want to convert a character field to numeric. > > For Micrsoft or Sybase SQL server v6.5 the select statement is: > Convert(char,Tablename.Customer_ID) > > Does Informix have something like that? > > Thanks in advance > > Alex > > >

↪ replying to Sergey E. Volkov

Alex Bernaards — Fri, 03 Nov 2000 17:48:59 GMT — source: Informix-list mailing list archive (1991-1998)

Working on 7.24, switching to 7.31 in a couple of weeks. So, does 7.31 support this? Alex "Sergey E. Volkov" wrote: > Depends on version of IDS. > For example for IDS-9.x > > tablename.customer_id::char(10) -- ala c++ > > In earlier versions of IDS this isn't supported. > > Pietje Puk <Pietje@puk.com> ÐÉÛÅÔ × > ÓÏÏÂÝÅÎÉÉ:3a028dde$0$25544@news2.zeelandnet.nl... > > Hi, > > > > I want to convert a character field to numeric. > > > > For Micrsoft or Sybase SQL server v6.5 the select statement is: > > Convert(char,Tablename.Customer_ID) > > > > Does Informix have something like that? > > > > Thanks in advance > > > > Alex > > > > > >

↪ replying to Alex Bernaards

Art S. Kagel — Wed, 08 Nov 2000 14:09:25 -0500 — source: Informix-list mailing list archive (1991-1998)

What are you using for a front-end? Know that Informix automatically converts fetched columns to match the type of the corresponding host/bind variable if possible. So if you want to fetch that char column into a numeric host var in ESQL/C, 4GL, or CLI just do it. If it cannot be done, ie a row contains a non-numeric value, you will get a -12xx error code. Art S. Kagel Alex Bernaards wrote: > > Working on 7.24, switching to 7.31 in a couple of weeks. > > So, does 7.31 support this? > > Alex > > "Sergey E. Volkov" wrote: > > > Depends on version of IDS. > > For example for IDS-9.x > > > > tablename.customer_id::char(10) -- ala c++ > > > > In earlier versions of IDS this isn't supported. > > > > Pietje Puk <Pietje@puk.com> ÐÉÛÅÔ × > > ÓÏÏÂÝÅÎÉÉ:3a028dde$0$25544@news2.zeelandnet.nl... > > > Hi, > > > > > > I want to convert a character field to numeric. > > > > > > For Micrsoft or Sybase SQL server v6.5 the select statement is: > > > Convert(char,Tablename.Customer_ID) > > > > > > Does Informix have something like that? > > > > > > Thanks in advance > > > > > > Alex > > > > > > > > >