Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to have select column not print

Status
Not open for further replies.

glendacom

MIS
Oct 23, 2002
36
US
I have a need to have a column from a select statement not print in the results. For example in the following select statement I don't want the age to print:

select name, age, salary
from sometable

Results wanted:
==========================
Name Salary
George $1000
Tom $500

Is there a way to do this?

Thanks,
Glenda
 
Why don't you just select name and salary? WHat is purpose behind having age in the select statement?
 
I am using this query within an ASP program and I need the value in the field but don't want it to show up on a drop down list. Therefore I need to have it in the select statement but don't want it to print. I know how to do this in Oracle but can't figure out how to do it in SQL*Server.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top