[RBASE-L] - Re: how to do a right(string,n) in rbase

[Jason Kramer]

You might be able to save yourself some trouble if you just copy the age column to a temporary table that has the age column defined as an integer. Jason Kramer University Archives and Records Management 002 Pearson Hall (302) 831 - 3127 (voice) (302) 831 - 6903 (fax) On 7/9/2010 4:22 PM, 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