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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I put a constant in a database view? 1

Status
Not open for further replies.

ITmfgCO

IS-IT--Management
Sep 14, 2006
25
US
I am creating a DB view to integrate our ERP with UPS WorldShip. In this view I need to provide information that is not stored in the DB. Can I somehow insert a column in this DB view that for every record it returns there is a column named "Origin" and the constant value is "China" If so, how would I go about doing this?

Thanks for your help!
 
CREATE VIEW v_SomeView

AS

Origin = 'China',
Column1,
Column2,
Column3,
Etc.
FROM SomeTable
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top