News

What I want to do, though, is if the values in a serial number field for a given query are all numeric values, I'd like to sort them in normal numeric order (1,2,3...10, 11, 12).
When selecting the data, I was expecting the zero values to be returned as 0.00 or 0, but they were returning as .00.<BR>So, I changed some fields to numeric (8,2), hoping that would help.