Re: sorting a nummeric list

Olav: > I can't redifine the field as it is also used as for holding text values in > other records! Sounds like poor database design to me. Anyway, one possiblity is to format strings as they go into the database or as they come out of the database using sprintf(). If on the way out, sprintf() the data as you stick it into an array, then sort the array. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y More than just answers. Solutions. (SM) http://www.analysisandsolutions.com/ 4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409