How can I fix the sorting order for numbers?
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