How do I format this case statement in sql? -

Actually, I want to return a 1 if field blue is a y ' and if this is not empty. Is it that I should go about this? When Blue = 'Y' then 1 and '' end

You can either

  case isnull (blue, 'n') when 'wi' then when unaware (blue, 'N') = 'y' and '1' and '' '' '' '' '' '' expiry