Absolutely.

RPAD('<a href="mailto:' || RTRIM(C.EmailAdd) || '">'
 || RTRIM(C.EmailAdd) || '</a>', 80) as FromStudentEmail

The double pipes || are what you use to concatenate strings and/or columns together. I RPAD the results so rows after the first one selected that have longer e-mail addresses will have enough width. I just picked 80 to be the column width. You should use enough to accommodate the width of you e-mail address column plus the widths of what ever strings are concatenated to it.

The second "C.EmailAdd" above could also be the student's name as well.

>Thanks, it works but is it possible to add a fix string (ie. "mailto: ") infront of "B.EmailAdd AS FromStudentEmail" and "C.EmailAdd AS ToStudentEmail" .. so I will get
>
>mailto: user1@mydomain.com
>mailto: user2@mydomain.com
>
>please advise
>
>Regards
>Winanjaya