Bracket comparison

[EagleTempest]

SQL Server 2000 and .Net 2.0

Is there a difference between

WHERE (@RegionID IS NULL OR Region = @RegionID)

and

WHERE (@RegionID IS NULL) OR (Region = @RegionID)

The first gives me the results I want. The Query Builder in VB 2005 tries to be too smart and changes the first one to the second one automatically.

Thanks.

 

[ESquared]

No.

[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.

_{The best part about anything that has cheese is the cheese.}[/color]

 

[AlexCuse]

There will be a difference if you start adding onto your where clause. Better to start weaning yourself off of any kind of GUI query building tools now, IMO.

[small]----signature below----[/small]
I can't compete with you physically, and you're no match for my brains.
You're that smart?
Let me put it this way. Have you ever heard of Plato, Aristotle, Socrates?
Yes.
Morons!