Viewing 3 posts - 1 through 3 (of 3 total)
Put the statements after the AS keyword
Syntax reference:
http://msdn.microsoft.com/en-us/library/ms187926.aspx
November 28, 2011 at 4:56 pm
#1413705
Yes, that's a good idea to convert null to something useful for a comparison. That would work also. I circumvented the comparison problem by using my @Parameter as...
August 12, 2011 at 2:02 pm
#1368208
I think I figured it out.
WHERE (@Parameter IS NULL OR (@Parameter IS NOT NULL AND someflag = 1))
August 12, 2011 at 12:44 pm
#1368161