Using Distinct on Group of Names

[saw15]

Good day ..

We keep a historical table of all users who submit a job. This table, logs the user name how they have logged into the db that day, example. User logs in as User1 or user1 or USER1.

I need to run a distinct on the group of user names, that does not compare case each name, so User1, user1 and USER1 would result in a count of one, not three.

Help is much appreciated.

 

[OraCool]

Try This

Select distinct(lower(UserName)) from the HistoryTable;