Re: Order array of char as number

Dipl. Ing. Michael Wald T. 06838-866-177 wrote: > = > We have defined a table where every row stands for an article. > The key-column is a array of char=B4s . Unfortunately, the customer > is using article-numbers - no problem to transform it in a string. > However how can we order a select related to the number-value instead o= f > alpahbetical order ( 1111 comes before 999 ) > Thank you for help > = > Michael > :) You have to convert it into a string with the 'using' clause as: LET string =3D number USING "&&&&&&" # ONE '&' FOR EACH DIGIT IN THE NUMB= ER This will make stings like "000999" or "001111". These will sort the way you want. BTW, why didn't you just user an 'integer' type column? -- = Christopher Sharrer Luminous Chao, Inc.