But the other important aspect is 'inserts' which would result 2 rows if the values are 'A' and 'a'. Intent here to have it case insensitive.
If CITEXT it will update the same row and works. CITEXT is an alternative but was wondering if there is any other alternate solution/setting while creating database.