ORDER BY

[Vincent S]

Hi all,

I have an sql table that I want to ORDER BY Alphabeticaly "easy" but there are some results that have a "*" in front. Now these all display first but I want them to display last, how can this be achived?

WHAT IT CURRENTLY DISPLAYS
*A
*B
*C
D
E

WHAT WANT IT TO DISPLAY
D
E
*A
*B
*C

[Ronald Wernecke]

After asterisk is comming before any letter, it is ordered first.
I assume the asterisk has some meaning - just move it to a new field, so it is excluded.
How you display the result is your bussines.