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
 
Sort by date Sort by votes
M

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
You must log in or register to reply here.

Similar Threads

  • Locked
  • Sticky
  • Article
Android Tutorial [B4X] "Code Smells" - common mistakes and other tips
2 3
Replies
43
Views
89K
Erel
  • Locked
  • Article
B4A Library [B4X] B4XTable - Cross platform, sortable, searchable, customizable table
2
Replies
28
Views
61K
Erel
P
  • Question
Android Question Sort from SQL
Replies
4
Views
880
eps
M
  • Article
B4A Library [Class] Flexible Table
63 64 65
Replies
1K
Views
279K
klaus
  • Question
sql sort
Replies
2
Views
2K
tufanv
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…