Changes

This query lists the duplicate enumvalues created after the upgrade scripts(ICR-297). Note that the functions ''lower'' will be used so duplicates like Evidence Point and Evidence point will be found, ''trim'' will find " Active" and "Active" and ''replace'' will find Cluster Accident and ClusterAccident.

SELECT imsmaenum.enumcategory, replace(lower(trim(imsmaenum.enumvalue)), ' ', ''), COUNT (imsmaenum.imsmaenum_guid)FROM imsmaenumGROUP BY imsmaenum.enumcategory, replace(lower(trim(imsmaenum.enumvalue)), ' ', '')HAVING COUNT (imsmaenum.imsmaenum_guid) > 1ORDER BY imsmaenum.enumcategory ASC 1, imsmaenum.enumvalue ASC2