Order by or sortkey

Last Reply 5 days ago By kalpesh

Posted 13 days ago

Hi All, I have been trying to work on the order / sortkey for several days now and still can't come up with a solution.

I am using MS SQL 2014. One of my column (fruit) has data like this:

apple 1-100
apple 1-9
apple 1-15
apple 1-201

if my sql says: "Select fruit from tablename order by fruit" then it appears like this:
apple 1-100
apple 1-9
apple 1-15
apple 1-201

the correct order should be:
apple 1-9
apple 1-15
apple 1-100
apple 1-201

is it possible to sort it correctly using ORDER BY in the SQL query.

Thanks so much in advance. 

You are viewing reply posted by: yinyang205 7 days ago.
Posted 7 days ago

Humm....let me go through all the values again. Thanks.

I agree, here is the link: http://e-iceblue.com/free-api