to select upper case email address from table
840912Mar 2 2012 — edited Mar 5 2012Hi guys
I want to select upper case email address from below table
email
column
THER_WARD@DELL.COM
ne_james@gmail.com
ER_MEYER@GMAIL.COM
Ba_Vanderkelen@gmail.com
Wolf_Meller@gmail.com
Ther_Ward@Dell.Com
KIRSTEN_KPF@GMAIL.COM
Car_Smith@gmail.com
Krist_Stallert@gmail.com
LOUISE_DONNELLY@GMAIL.COM
MARTIN_MANN@GMAIL.COM
dier_Rene@gmail.com
er_meyer@gmail.com
louise_donnelly@gmail.com
Martin_Mann@Gmail.Com
Er_Meyer@Gmail.Com
ther_ward@gmail.com
output
THER_WARD@GMAIL.COM
ER_MEYER@GMAIL.COM
KIRSTEN_KPF@GMAIL.COM
LOUISE_DONNELLY@GMAIL.COM