Topic: Newbie at Oracle


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)...

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...

Cheers,
Chip


dlackey    -- 10-10-2007 @ 5:50 PM
  Ah, the command is lower, not lcase.

Thanks anyway!

Cheers,
Chip


EasyCFM.COM ColdFusion Forums : http://archive.easycfm.com/forums
Topic: http://archive.easycfm.com/forums/viewmessages.cfm?Forum=33&Topic=12449