Mimic Windows Explorer sorting by filename

Mimic Windows Explorer sorting by filename

am 01.04.2008 17:13:44 von weboweb

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