Thank’s Marcus!
I’ll try that tomorrow!
Here is the issue in the visual aspect!
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!