0

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.

3
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by debasisdas
0

can you please explain - in which format you want this data??

if you want email concatenating with name, you can simply use "||" (without quotes)

like

select lower(trim(email)) || lower(trim(name)) from mail;

or if you want in separate columns then you need to replace "||" with "," only(again - without quotes ).

what you have done it is looking correct only.

:)

Edited by pratik_garg: n/a

1

I really do not understand what do you mean by -- I ran ltrim(), rtrim() and lower() function on data successfully. But fail to retrieve this data.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.