SQL Sort By query

mangojack

Expert
Licensed User
Longtime User
Just starting to touch on the finer points of SQl queries, namely SORT BY.
It would appear UpperCase gets presidence over Lowercase.
Is there a Query method/parameter to disregard Case or is it best to start housekeeping users input regards capitalization on first character ect.

Cheers mj
 

Mahares

Expert
Licensed User
Longtime User
You can use something like this in your query. It will convert everything to upper case, but will not physically change you table records:
SELECT * FROM MyTable ORDER BY UPPER(FIELDX)

Or you can also use:
SELECT * FROM MyTable ORDER BY LOWER(FIELDX)
 
Upvote 0

mangojack

Expert
Licensed User
Longtime User
Thanks Mahares .. good to know there is an option to go that way if I decide.
Cheers mj
 
Upvote 0
Top