I'm not sure how often tables are added to the database and how many of these tables will need to be audited.

I don't know if there're common threads between all...

Arun...is this what you're looking for ?!

select column_name, data_type from information_schema.columns where table_name = 'authors' and column_name = 'au_id'

"Can you see any of the school systems in the US or even other countries coming up with contracts and outsourcing IT to India (or some other country)? Any universities?...

I'm willing to start anything that's not a "moo point" Remi...

sswords - you call that "sucking up" ????????

All you did was philosophise a bit about Life in general and ssc in particular...where's the kudos due to the "site owners" ?!?!

I...

..to jump in...it updates the existing column...if (as AJ suggests) you have only US zipcodes, you can replace your statement with:

update dbo.mci_geocodable set zipcode_2 = left(zipcode_2, 5) where right(zipcode_2,4)='0000'

Steve - I'd like a book please....I've only said (about a hundred times...) that this is the best darn site there is - & soooo "as good as it gets.."...

Do it in QA with "update table set stateID = ...where rows = ...."

That's strange - if the tables don't exist in sysobjects then you should get no rows back...

how about if you just query sysobjects with:

select uid, name from sysobjects

where name...

Mike - I was telling Remi about the 2nd time round misunderstanding...you're too savvy to do any such thing ...however, the bad news is...

That's the second time you've misunderstood something I've said in just one morning 🙁

I meant update the 2nd column with right data (whatever that is)...also if the values in both...

Mike - I completely overlooked the fact that the 2 columns have duplicate data (stupid me..) - he should actually be updating col2 with the right data...

I think (therefore I...

This sounds facetious but isn't - sufian needs help in more ways than one...but on the ssc forums the only help requested is matters pertaining to sql server and it's...

I don't know if setting it up in the Model db will work (maybe someone else will tell you if it will but meanwhile you could always test it by...

Thanks for the feedback - I've just finished reading the contents of another forum where people were complaining about lack of feedback...: