AND CASE 
	   				WHEN um.Term_DT			<= mm.Term_DT		 THEN um.Term_Dt  
	   				WHEN um.Term_DT			<= mm.Expiration_DT  THEN um.Term_Dt 
	   				WHEN um.Term_DT			IS NOT NULL 
	   				 AND mm.Term_DT			IS     NULL 
	   				 AND mm.Expiration_DT	IS     NULL			THEN um.Term_Dt
	   				 
	   				WHEN mm.Term_DT			<= um.Term_DT		THEN mm.Term_Dt
	   				WHEN mm.Term_DT			<= mm.Expiration_DT THEN mm.Term_Dt
	   				WHEN mm.Term_DT			IS NOT NULL 
	   				 AND um.Term_DT			IS     NULL 
	   				 AND mm.Expiration_DT	IS     NULL			THEN mm.Term_Dt
	   				 
	   				WHEN mm.Expiration_DT	<= um.Term_DT		THEN mm.Expiration_DT  
	   				WHEN mm.Expiration_DT	<= mm.Term_DT		THEN mm.Expiration_DT 
	   				WHEN mm.Expiration_DT	IS NOT NULL 
	   				 AND mm.Term_DT			IS     NULL 
	   				 AND um.Term_DT			IS     NULL			THEN mm.Expiration_DT
	   		        ELSE  '01-01-1900'
	   			END > CONVERT(varchar(10),GETDATE(),1)
)

CREATE TABLE #User_Message(Group_Trans_Id int, AKA_Id char(12), Term_Dt Date)
GO

INSERT INTO #User_Message(Group_Trans_Id, AKA_Id, Term_Dt)
SELECT 1, 'X002548', '1900-01-01' UNION ALL
SELECT 2, 'X002548', '1980-02-29' UNION ALL
SELECT 3, 'X002548', '9999-12-31' UNION ALL
SELECT 4, 'X002548',  null		  UNION ALL
SELECT 5, 'X002548',  GETDATE()   UNION ALL 
SELECT 6, 'X002548',  null
GO

CREATE TABLE #myMessage(Group_Trans_Id int, Term_Dt Date, Expiration_Dt Date)
GO

INSERT INTO #myMessage(Group_Trans_Id, Term_Dt, Expiration_Dt)
SELECT 1, '1900-01-01','1900-01-01'  UNION ALL
SELECT 2, null        ,'1900-01-01'  UNION ALL
SELECT 3, null        , null		 UNION ALL
SELECT 4, null        ,'01/01/2011'  UNION ALL
SELECT 5, '01/01/2011',null			 UNION ALL
SELECT 5, null        ,null
GO

DROP TABLE #User_Message, #myMessage
GO

COALESCE( um.Term_DT, mm.Term_Dt, mm.Expiration_DT)
> CAST(CURRENT_TIMESTAMP AS DATE) --CONVERT(varchar(10),GETDATE(),1)

SELECT *
FROM
    (
        SELECT 
            um.Group_Trans_Id,
            (
                SELECT MIN(D.Val)
                FROM
                   (
                        SELECT um.Term_DT AS Val UNION ALL
                        SELECT mm.Term_Dt AS Val UNION ALL 
                        SELECT mm.Expiration_DT AS Val
                   ) AS D
            ) AS  MinDate      
        FROM
            #User_Message AS um
        INNER JOIN  
            #myMessage AS mm
            ON um.Group_Trans_Id = mm.Group_Trans_Id
    )  AS T
WHERE
    MinDate > CAST(CURRENT_TIMESTAMP AS DATE)

SELECT		um.Group_Trans_ID,
		MIN(u.theDate) AS Term_DT
FROM		#User_Message AS um
INNER JOIN	#MyMessage AS mm ON mm.Group_Trans_ID = um.Group_Trans_ID
CROSS APPLY	(
			VALUES	(um.Term_DT),
				(mm.Term_DT),
				(mm.Expiration_DT)
		) AS u(theDate)
GROUP BY	um.Group_Trans_ID
HAVING		MIN(u.theDate) > CAST(GETDATE() AS DATE)