EasyCFM.COM ColdFusion Forums / Oracle Related Issues / Newbie at Oracle

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Newbie at Oracle

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

dlackey
10-10-2007 @ 5:41 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 935
Joined: Jun 2007

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
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 935
Joined: Jun 2007

Ah, the command is lower, not lcase.

Thanks anyway!

Cheers,
Chip


Website Designed and Developed by Pablo Varando.