I am trying to figure out a statement that will update multiple records at a time. I found our db has State records that are spelled out instead of abbreviated. Example: New Jersey instead of NJ. So my question is how can I do many at once instead manually updating each state at time.
--one state at a time
SET State_Province = 'NJ'
WHERE State_Province = 'New Jersey'
So I want a script that can do all of these at once. Thanks for any help!
District of Col DC