Hi 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
