AnsweredAssumed Answered

How can I fix the sorting order for numbers?

Question asked by carolynhaywood on Sep 8, 2011
Latest reply on Sep 8, 2011 by raybaudi

Title

How can I fix the sorting order for numbers?

Post

 My database is sorting numbers this way: 1 10 12 2 etc. How can I fix that?  Also, if I do a find for a number field for a range of 6000...6999, it returns those records but also any record with 6 in it. AND.  A differnt problem:  I have a script that sets a variable for employee name $emp = "jr".  and does a find for "jr".  the find returns all values for jr such as jrh, jrb etc.  I'm trying to find the employee, then set the employee number so this really messes me up.  I am dealing with over 60,000 records.  Anything I can do to keep it finding "jr" only? Thanks, Carolyn Haywood

Outcomes