All all, I fill a list with content of DB
It is ok that order by query run upper case first and lower case after?
B4X:
dim listItem as list
listItem.initialize
dim cursor1 as Cursor
cursor1=Stater.sql.ExecQuery("select * from table order by Name")
for x=0 to cursor1.RowCount-1
curcor1.Position=x
listItem.Add(curseur.GetString("Name"))
Nextapple
Zoro
Google
tomato
zerox
Zoro
tomato
zerox
Google
Zoro
apple
tomato
zerox
Zoro
apple
tomato
zerox
It is ok that order by query run upper case first and lower case after?