Link to home
Create AccountLog in
Avatar of thatelvis
thatelvis

asked on

Update table

Hello,

I want to update a column in my sql 2005 database where the present value of that column is null.

I want to update  cityTbl.CityPK column to value     AT       if its null at present. can some one help me out with the sql.

update cityTbl.CityPK
FROM cityTbl
WHERE cityTbl.CityPK is null


regards

k
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of thatelvis
thatelvis

ASKER

Thanks I was going throught some books and things but i was afraid i would muck up the db lol. hope your well and thanks again.