The order of the output, SQL(??)

Thank’s Marcus!
I’ll try that tomorrow!

Here is the issue in the visual aspect! :slight_smile:

Not very fancy, right!?
Hmm… Maybe it’s better to sort in Xojo!? Rather than in SQL!?
It’s actually also an alternative as I will consider!
Because every post has ParentID = 0 so they can be separated by the others!
I’ll think of this alternative as well!

Then I can also replace the stars as they do not add any positive feelings…!

[quote=216110:@Marcus van Breemen]If you want to sort on the asterix only in the first column, then this works:

SELECT SomeText FROM SomeTable ORDER BY CHARINDEX('*', LEFT(SomeText, 1)), SomeText

NB: This example assumes MSSQL (Transact SQL).[/quote]

I see that you’re using MS Access. In that case you should use this:

SELECT SomeText FROM SomeTable ORDER BY INSTR(LEFT(SomeText, 1), '*'), SomeText

Thank you!
I don’t understand why it works but it works and for me, it’s good enough!