Dennis,

try this:

IF EXISTS (SELECT TABLE_NAME

    FROM   INFORMATION_SCHEMA.VIEWS

    WHERE  TABLE_NAME = N'Spain_Orders')

    DROP VIEW Spain_Orders

GO

CREATE VIEW Spain_Orders

AS

 SELECT

 [Order ID],

 [Customer],

 [Employee],

 [Order Date],

 [Required Date],

 [Shipped Date],

 [Ship Via],

 [Freight],

 [Ship Name],

 [Ship Address],

 [Ship City],

 [Ship Region],

 [Ship Postal Code],

 [Ship Country] as [DestinationSpain]

 FROM Orders

 WHERE [Ship Country] = 'Spain'

GO

to change a colum name, you need to use an alias for that column name. The syntax is allowed in the SELECT statement: ... ColumnName As AliasName

By the way, you could this the alias as the heading of the column in the SELECT statement or by creating the view as you want to do.

Ben Lopez