Re: Sorting Integer

In article <1m0d5dINN79m@emory.mathcs.emory.edu> alan@effluvia.den.mmc.com (Alan Popiel) writes: >->The trunc function with a precision of -2, will change the last two digits of >->the number to zeroes. Then subtracting your original number from this >->truncated number and changing the sign will give you a column containing the >->last two digits of your original number which you can then sort by. >-> >->Hope this is of some use! >-> >->Cathy > >Cathy, > >What version of Informix ISQL/ACE/engine/etc. are you running? I looked for >the TRUNC function in my 4.00 (and 4.10 supplement) manuals and did not see >it. Is it an ACE feature? I know you use ACE a lot, while I don't use it >at all. I see that Alan Denney tells us that MOD became available in v5.00 >of the engine. TRUNC is supported by at least the 4.1 engines for SQL. It is documented in the Informix Guide to SQL: Reference for 4.1; check the index. I would doubt it would be supported by ACE. I know it is not supported by 4GL 4.1 (I just tried it).