Re: SQL/INFORMIX (UPPER)

Posted in 1997

Mark D. Stock — Fri, 02 May 1997 13:15:18 +0200 — source: Informix-list mailing list archive (1991-1998)

Jonathan Leffler wrote: > > >From: Nils Paulsson <nils.paulsson@mailbox.swipnet.se> > > > >I am not at all oriented (yet) in programing Informix procedures but why > >on earth using tons of if:s when the conversion for the letters "a" to > >"x" can be done by adding a konstant to the ASCII-code? > > Because you can't get the ASCII code of a character into an integer in SPL... > > Nor vice versa. > > :-(((( That's a very long-faced frowney (non-smiley) > > It's due to be fixed in a forthcoming release (9.20 from what I've heard, > no date on availability). I only hope that it gets back-ported to 7.x and > 5.x product lines too. Great! Me too! Shall I start a vote for this too? :-) -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+