Mimic Windows Explorer sorting by filename

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
weboweb [ Di, 01 April 2008 17:13 ] [ ID #1932847 ]
Datenbanken » comp.databases.ms-sqlserver » Mimic Windows Explorer sorting by filename

Vorheriges Thema: Re: Doing Summation on multiple criterias on the same column in a
Nächstes Thema: Default storage space - DB engine tuning advisor