Do you want to sort this using SQL code or Delphi code? I believe every database is different, for instance Oracle will sort lowercase first but there is a function to ignore this and convert all to uppercase.
If you are sorting a list in Delphi you can use the string handling routine UpperCase() to sort correctly.
Comments
Do you want to sort this using SQL code or Delphi code? I believe every
database is different, for instance Oracle will sort lowercase first but
there is a function to ignore this and convert all to uppercase.
If you are sorting a list in Delphi you can use the string handling routine
UpperCase() to sort correctly.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com