here's the set up as to why... When you sort text ages it is like so... 110 1 10 2 24 3 32 33 38 etc...
it's not exactly as intended, so I'd like to add proceeding zeros and in sql it's
right('00'+age,3)
ie add the zeros and get the 3 charactors starting with the last
so the samples would then sort as...
001
002
003
010
024
032
033
038
110
how would I do that in rbase?
Rachael M
Freelance Developer
(218) 326-2719
www.DragonflyDevelopmentMN.com
