This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Kunal Lakhani wrote:Thanks for your reply Martin Vajsar.
I used INITCAP function.
It is up to you to decide which records should be considered identical and which different. INITCAP does something different than UPPER, but if INITCAP meets your criteria, so be it. Using INITCAP to define uniqueness seems a bit strange to me, though (you're disregarding only the case of letters at the beginning of words, that looks quite arbitrary to me).