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 ??