View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Himansu Himansu is offline
external usenet poster
 
Posts: 40
Default T-SQL with a added field

Hello everyone,

Anyonme know how to add a field to a query? I want to add a field with the
same data in all rows.

Example:

select name, id, company
from test

* There is no company field in the test table, but I want to add it to my
result with all company data equal to HHA.

Any help will be greatly appreicated.

--
Thanks,
Himansu