I have a table with City as column name and when I group by city I cannot distinguish between Dallas and DALLAS. They both are counted under Dallas. Even when I try to update Dallas to DALLAS all rows try to get updated instead of the ones with the exact case.
Is there any way to identify them separately?
Is there any way to identify them separately?