Mimic Windows Explorer sorting by filename
am 01.04.2008 17:13:44 von webowebHi all,
Does anybody know if it's possible to mimic the window explorer
algorithm (which I don't know) to sort by filename from SQL server?
Suppose I have a table with the field "myFileName" and I want a
resultset sorted by that field.
SELECT * FROM myTable ORDER BY myFileName
but I want the resultset ordered as windows explorer would do it, not
the regular alpha sort.
Any ideas?
Thanks
webO