Hi all...here is a quickie for ya:
Given:
User_Email|User_ID
-------------------
fubar | 1
barfu | 2
snafu | 3
Fubar | 4
What query could I use to return ONLY 'fubar' and 'Fubar'? Would I do a self
join? The problem is that I'd forgotten to force everything to lowercase upon
insertion, and now I need to clean out the uppercase records and/or convert them
to lowercase.
Ideas?
-=pierre