CAST(10 as sql_variant)  로 먼저 처리..

SELECT NO,GB

   FROM (

                SELECT NO ,(CASE WHEN no = 1 THEN CAST(10 as sql_variant) 

                                              WHEN no = 2 THEN '02'

                                              WHEN no = 3 THEN GETDATE()

                                              WHEN no = 4 THEN 24.6666

                                     ELSE 'No Comments'

                                     END )  GB

            FROM ( SELECT 1 NO UNION  SELECT 2 NO UNION SELECT 3 NO UNION SELECT 4 NO  UNION SELECT 5 NO ) A ) RA

 ORDER BY  GB

GO

 SELECT *

    FROM  (

                  SELECT  CAST( 1 AS  sql_variant   ) NO

                                            UNION ALL

                                            SELECT  '02'

                                            UNION ALL

                                            SELECT  GETDATE()

                                            UNION ALL

                                            SELECT  24.6666

                                            UNION ALL

                                            SELECT  'No Comments' ) R

 ORDER BY NO

GO