Ignore case when ordering in listview

[Dman]

I am populating a listview from an sqlite db and I am retrieving the lastname and firstname and ordering them by lastname. That works fine but there are some rows that the last name is lower case and some that are upper case. Is there a way to ignore that when displaying in the listview?

 

[kickaha]

Try COLLATE NOCASE

 

[Dman]

Thank you. That worked great!