How can I make sort a result from a query used in an API by case insensitive?
Here is some sample data in a sortBy field:
Apple
ape
Abe
apricot
Bernie
banana
Button
bill
-------------------
After sorting using Xano the results are:
Abe
Apple
Bernie
Button
ape
apricot
banana
bill
--------------------------
However I'd like to have the following:
Abe
ape
Apple
apricot
banana
Bernie
bill
Button
-----------------------
How can I accomplish this?