SQL Server data type ?

[moospot]

I am trying get the shoe sizes in my database to display correctly.

They are now set to text so they display out of order, like so:

10
11
12
7.5
8
8.5

Now, I've tried a few different data type (numeric, decimal, etc) but can't seem to get the result I want.

I need one decimal point in the half sizes and no decimal points on the whole sizes.

Can someone please help me ??

[shane]

Try using a decimal with precision:3 and scale:1.

[moospot]

Worked...Sweet! Thanks