Re: Informix SQL query on INTEGER column

John Fowler writes, > > 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) > Someday I'm going to think of these things before I fire out an answer. j. _____________________________________________________________________________ Jack Parker - Contractor | Hewlett Packard, BSMC Boise, Idaho, USA| If you keep staring at it like that, jparker@hpbs2561.boi.hp.com | your nose is going to grow (208) 396-5388 (W) (208) 384-1623 (H) | into the bark. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________