We have recently upgraded our SQL and are having the same issue, but I don't know how to change my statement to get blank results instead of "null" in my result set. Can you show me what to change?

SELECT MPIN, ProvType, LastName, FirstName,

Case

When PrimSpec='040' then MI else null end as MID

FROM dbo.PROVIDER