Ok.... got the cursor working.

Thought I would share an example of one way to do it.

if exists (SELECT * FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'Unit_SRC_missionSupplies' AND

COLUMN_NAME = 'SupplyClass')

BEGIN

DECALRE @supClass as...

I will re-look at what I tried to get working.

Thanks again.

Mark....

Yes... "like" that:)

I did try and get the dynamic sql to work with a Cursor.... no luck there.

It was my last warning, and I wanted to put this pig to...

So.... something like this?

declare @updatestatment =

N'UPDATE Unit_SRC_PopSupplies SET Supply_Type_Key = @supKey

...