Hello, we have develop a builder web app and here we stores plot nos of particular layout.
My client says that show all plots in ascending order. But plots are not always numeric value
it could be like
1
2
3+4
10 and 11
also I can't assign serial no like any field to this because user can edit or add later on new value
like in my case after entering above data he can add later on -
5
6
7,8,9
So, is there any way to show this data in ascending order
I tried
select * from tablename Order By CAST(PlotNumber as Int) ASC
but gives an error. Can anyone suggest good solution