CodeFlunkie

update franchiseeTable set franchiseeTable .postal_code_territory_id= a.postal_code_territory_id from franchisee_zips z inner join postal_code_territory a on z.pid=a.tdg_pid

So you can't do this: where e.myfield=myEnum.myvalue or this where e.myfield=1 when myfield is a nullable integer In that situation you need to use .Equals Like this: where e.myfield.Value.Equals(myEnum.myvalue) Voila!