Hi to all,
table name: mail
email name
abc@gmail.com abc
def@rediff.com def
pqr@yahoo.com PQR
xyz@daniweb.com XYZ
=======================================
QUERY:
List all email and names in lower letters without any blanks.
========================================
I ran ltrim(), rtrim() and lower() function on data successfully. But fail to retrieve this data. Will you please help me? I don't have any little bit idea about code.