mangojack Expert Licensed User Longtime User Jan 21, 2013 #1 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
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
M Mahares Expert Licensed User Longtime User Jan 21, 2013 #2 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
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 Expert Licensed User Longtime User Jan 21, 2013 #3 Thanks Mahares .. good to know there is an option to go that way if I decide. Cheers mj Upvote 0
