When I run a query against an SQL server database with an ORDER BY clause, the result set is ordered “alphabetically”:
Query:
SELECT Product_VAMID FROM Product ORDER BY Product_VAMID
1060-a
1060-s
11-a
11-s
1645-a
1645-s
I need to order it “numerically”:
11-a
11-s
1060-a
1060-s
1645-a
1645-s
How can I achieve this? I have tried several different ways, and searched everywhere, but I cant seem to find a way. All help appreciated.
thanks in advance.
