We receive a file from one of our partners that contains first and last name.
We need to order the file by name, but they send us mixed case names.
Is there a way to create an index of some type by using either the upper or lower function on the name fields?
I thought I had done this in Oracle SQL, but it could have been one of those dreams.
Thanks for your input.