>I need one SQL statement that will return records with no duplicates based on case:
>
>

>Raw data example:
>
>Aa
>Bb
>CC
>aa
>Dd
>bb
>aA
>ee
>
>Desired result set:
>
>Aa
>Bb
>CC
>Dd
>ee
>

You might want to try

SELECT MIN(field) ... FROM ....