database has list of usernames, some uppercase and some are lower case. I need to select usernames that match (caseinsensitive)...
select lcase(username from table where username = 'abc123'
This query isn't finding the value abc123 since the username is actually ABC123. What do I need to do different? I tried "where username = lcase('abc123')" but that generates an error.
I coudn't be any more greener with Oracle. I'm more familiar with SQL...
dlackey
10-10-2007 @ 5:41 PM
