Hi,
I have a data table with shop products in it.
I want to order the data on the 'size' column.
This can be shoe size (9, 10, etc) or it could be shirt size (Large, Medium, etc).
When I order by alphanumeric, the shoe size list looks wrong as it shows this:
10, 10.5, 11, 11.5, 6, 7, 8, 9
But, if I order by numeric (Using CAST for example), it obviously doesn't like the alpha sizes like 'Large'.
Anyone know a way to solve this? Or am I going about it in completely the wrong way (probably!)?
Thanks for any help.
I have a data table with shop products in it.
I want to order the data on the 'size' column.
This can be shoe size (9, 10, etc) or it could be shirt size (Large, Medium, etc).
When I order by alphanumeric, the shoe size list looks wrong as it shows this:
10, 10.5, 11, 11.5, 6, 7, 8, 9
But, if I order by numeric (Using CAST for example), it obviously doesn't like the alpha sizes like 'Large'.
Anyone know a way to solve this? Or am I going about it in completely the wrong way (probably!)?
Thanks for any help.