Query Problem

[ragavan]

Hi I have the following table with the values Name Number username displayname kind path gane 0 ganesh gane 0 \Root\ bane2 0 ganesh bane2 1 \Root\gane aane2 0 ganesh aane2 0 \Root\ hane1 0 ganesh hane1 1 \Root\gane I need a query which will give the output Name Number username displayname kind path aane2 0 ganesh aane2 0 \Root\ bane2 0 ganesh bane2 1 \Root\gane hane1 0 ganesh hane1 1 \Root\gane gane 0 ganesh gane 0 \Root\ Thanks in advance

[Pete OHanlon]

I assume you are wanting to sort on the name column here. If so, add ORDER BY Name to the end of your select.

Please visit http://www.readytogiveup.com/ and do something special today. Deja View - the feeling that you've seen this post before.

[TomGarth]

In looking at your data sorting wish, the only organization I see that makes any sense is to sort like "ORDER BY LEN([Name]) DESC, [Name] ASC".

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia