• If I am not wrong... This may be easier to understand.

    ----------------------------------------------------------------------------------------

    SELECT ID, ISNULL(CAST(IsAvailable AS VARCHAR), GETDATE()) AS IsAvailable FROM #Test

    -----------------------------------------------------------------------------------------