Another simple question, this time a constraint.

[kamazon]

Using the CBT Nuggets SQL 2000 training video, we created a constraint to limit the "State" field in a "Orders" Database to be limited to only PA, NY, and NY. Looking at the constraint through Enterprise Manager, I see this listed:

([State] = 'PA' or ([State] = 'NJ' or [State] = 'NY'))

Could anyone please tell me why there is a 2nd set of parenthesis after the first "or"? Thanks!

 

[r937]

obfuscation? misdirection? skullduggery? scalliwaggery?

as you have guessed, they aren't needed



r937.com | rudy.ca

 

[kamazon]

Phew, thanks. I was getting pretty confused. ^.^