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).
subject: Distinct values from multiple rows and columns