Newbie: If Then within where clause

[lcoppenr]

I'm trying to write the following stored procedure, but SQL has issues with the If statement. How do I include an case/if/etc into the where clause?

CREATE procedure [dbo].[MyProcedure]
@blnCheckbox bit = 1
As

Select Field1,
Field2,
Field3
From MyTable
Where Field1 like '%blah%'
and Field2 like '%blahblah%'
If @blnCheckbox = 0
Begin
and Field3 like '%blah%'
End

 

[LKBrwnDBA]

Maybe this would work:

CREATE procedure [dbo].[MyProcedure]
    @blnCheckbox bit = 1
As

Select Field1,
     Field2,
     Field3
From MyTable
Where Field1 like '%blah%'
     and Field2 like '%blahblah%'
     and ((@blnCheckbox = 0 and Field3 like '%blah%')
        or @blnCheckbox != 0 )

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[PHV]

Why not simply this ,
WHERE Field1 LIKE '%blah%'
AND Field2 LIKE '%blahblah%'
AND (@blnCheckbox != 0 OR Field3 LIKE '%blah%')


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886