is there an equivalent to Oracle's noprint?

[glendacom]

I am using a select within an ASP program to fill a drop down list. I need the select statement to initialize two variables but I only want one to be displayed. In oracle there is a way to define a column definition to be "noprint". Is there a way to do this in SQL*Server?

What I have is:

select lastname + ', ' + firstname as fullname,
lastname + ', ' + firstname + ' - ' + email as wmail
from aTable

I want the variable fullname to print but not wmail. wmail will be used elsewhere. Can this be done??

Thanks for any help.
Glenda