Re: Informix SQL query on INTEGER column

Posted in 1993

Harry Skelton — Thu, 5 Aug 1993 16:29:51 GMT — source: Informix-list mailing list archive (1991-1998)

In article <1993Aug4.165207.27659@wheaton.wheaton.edu> jcfowler@david.wheaton.edu (John C. Fowler) writes: .In article <2063@das13.snide.com> dave@das13.snide.com (Dave Snyder) writes: ..Have you tried dividing the field by 100 before displaying it? . .The main problem with dividing by 100 is that the number may be bigger than .99,999, in which case, you would get too many digits still. .(ie. 123456 / 100 = 1234) define char_number char(16) let char_number=number ...then peal off the first three chars from there... :) sorry....quick hack -- Harry Skelton President , United Systems Security Enterprise Marietta, Georgia 404-578-8085