SQL Sort By query

[mangojack]

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]

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)

 

[mangojack]

Thanks Mahares .. good to know there is an option to go that way if I decide.
Cheers mj