|dlackey||-- 10-10-2007 @ 5:41 PM|
database has list of usernames, some uppercase and some are lower case. I need to select usernames that match (caseinsensitive)...
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:50 PM|
Ah, the command is lower, not lcase.
|EasyCFM.COM ColdFusion Forums :||http://archive.easycfm.com/forums|