Simple SQL 2000 "OR" issue

[KAMAZON]

Hello, I am at the end of chapter 2 of SQL For Beginners and we are pretending that 2 states have merged into 1 megastate. I have to update our 2 tables that hold State info to reflect this change. Here is the query:


UPDATE MemberDetails
SET State = 'Mega State'
WHERE State = 'Stateside' or 'New State'


That does NOT work.



If I change it to read:

UPDATE MemberDetails
SET State = 'Mega State'
WHERE State = 'Stateside'

then also run:

SELECT STATE FROM MemberDetails

UPDATE MemberDetails
SET State = 'Mega State'
WHERE State = 'New State'


Everything works fine! Anyone have any suggs?

 

[agibby5]

Wouldnt you want to say:

WHERE State = 'Stateside' or State = 'New State'

 

[KAMAZON]

.......omg.

Thanks. >_>



As I've heard a million times "SQL never assumes anything, ever."

 

[agibby5]

I've only really started to work with SQL over the past two months... its been a rough time for me, to say the least... Glad to help! 🙂