Thread: Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
View Single Post

   
  #2 (permalink)  
Old 02-29-2008, 01:56 PM
--CELKO--
 
Posts: n/a
Default Re: Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
SELECT ..
FROM Foobar
WHERE
CHARINDEX (NULLIF(@myparam, ''), some_column) > 0

Reply With Quote