(FORMAT(INT(TextAge),'000')))
When you convert the textage to integer, then format it to 000 you get
the results you need.
Albert
Rachael Malberg wrote:
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
