that code will update all rows, instead of just what was just inserted.

i'd do it this way instead, but i don't know the PK of the table

CREATE TRIGGER country_Insert_Update

ON dbo.cis111_LMccrorey_Customers

AFTER INSERT,UPDATE

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

Update Customers

set Customers.Country = UPPER (INSERTED.Country)

FROM Customers

INNER JOIN INSERTED ON Customers.PKColumnName = INSERTED.PKColumnName

END

GO