Order by using numbers 1

[rtshort]

I have a TaxRate table that I fill a ComboBox with. In the sql statement I use "order by TaxRate" but it comes out wrong:

1.0
10.0
2.0
3.0
4.0
5.0
6.0
7.0
8.0
9.0

The 10.0 comes right after the 1.0. How do I get the 10.0 to come after the 9.0 like it should? Like:

1.0
2.0
3.0
4.0
5.0
6.0
7.0
8.0
9.0
10.0
11.0
etc....
Rob
Just my $.02.

 

[mwolf00]

Tax rate seems to be stored as text...

TRY This (sql Server)

SELECT cast(taxrate as int) FROM myTable ORDER BY cast(taxrate as int)

(Access)
SELECT cInt(taxrate) FROM myTable ORDER BY cInt(taxRate)

-- Just trying to help...
<--- This is a wolf? We need a new icon.......
mikewolf@tst-us.com

 

[rtshort]

Thanks Wolf, been away from the computer for a while. Rob
Just my $.02.