Checking for null in if statement

[crystaldev1]

Hello. I am using Sql Server 2005 and would like to run the following statement but it's giving me few errors:

SELECT ...

FROM ...

WHERE (if TABLE.FIELD IS NOT NULL then TABLE.bPRIMARY = 'True'
else '')

So I'm having a problem with the where statement. I would like to use the IS NULL or IS NOT NULL in IF statement if possible. Thanks.

 

[gmmastros]

IF is used to control the flow of logic. It's really meant for multiple queries. Ex: If row exists in table, update, otherwise insert new row.

To control DATA, you'll want to use the Case/When construct, like this:

[tt][blue]
WHERE Table.bPrimary = Case When TABLE.FIELD IS NULL
Then ''
Else 'True'
End
[/blue][/tt]

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom