[Nasulbad] Select

[visualAd]

Please don't move.

How can I select from a table where a certain value is on the top. Or something like the first result.

root
AnotherName
BEER
CCC
ZZZ

You should see the sample. Sorted by Asc but the root is on the top list. How do I select something like that. Thank you.

Assuming that your column is called user_name:

SELECT use_rname, LCASE(user_name) sorted
    FROM table_name ORDER BY sorted;

Assuming MS SQL has a function called LCASE()