Where clause CASE statement

Question

I was given pseudo code for a check to see if a date is between a stat date and end date and using a CASE statement change the end date to 99999999 if it is 0. I need to check if the date is in a 3 year range. I am not an expert on CASE statements and never used one in a Where clause before. This is enrollment info. Here is the code and I hope someone can help me out.

WHERE EligibilityHistory.CoverageGroupCode = '010218'

AND 20100601 between EligibilityHistory.EligibilityStartDateAND EligibilityHistory.EligibilityEndDate
Case When End = 0 then 99999999 Else End

Thanks to anyone that can help. I am not sure if this is the way to go, but I have to try.

arep

Vulpes · Answer

Try this: WHERE EligibilityHistory.CoverageGroupCode = '010218' AND (20100601 BETWEEN EligibilityHistory.EligibilityStartDate AND CASE WHEN EligibilityHistory.EligibilityEndDate = 0 THEN 99999999 ELSE EligibilityHistory.EligibilityEndDate END)