Case in Where clause

[rrchowdhary]

Hi all

I am struggling to get this query right but without any success. Any help would be really helpful

here is my query

SELECT * FROM tb_filters
WHERE Id=@filterId AND 

CASE @SectionFilter
  WHEN 'NeedsAndRisks' THEN sq.NeedsAndRisks  
	IN(SELECT item from dbo.fnSplit(@ScoreFilter, ','))
  WHEN 'SupportPlanning' THEN sq.SupportPlanning 
	IN(SELECT item from dbo.fnSplit(@ScoreFilter, ','))

Thanks
RR

 

[r937]

SELECT * 
  FROM tb_filters
 WHERE Id = @filterId 
   AND CASE WHEN @SectionFilter = 'NeedsAndRisks' 
            THEN sq.NeedsAndRisks
            WHEN @SectionFilter = 'SupportPlanning' 
            THEN sq.SupportPlanning
            ELSE NULL END
      IN ( SELECT item FROM dbo.fnSplit(@ScoreFilter,',') )

where does the sq table get defined?

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[rrchowdhary]

Thanks r937

This worked like a charm.

What I am trying to do is get all the filters matching perticular @SectionFilter and this is being used in a stored proc.