Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Newbie: If Then within where clause
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%'...
