-1

Why is the following query working inverse? I'd expect that asc order them in alphabetical order..

enter image description here

sharkyenergy
  • 3,842
  • 10
  • 46
  • 97

1 Answers1

1

Apply CAPS to the commands and apply 'NOCASE' function like:

SELECT * FROM giochi ORDER BY nomegioco NOCASE (ASC)
user12911589
  • 26
  • 1