Teradata - COALESCE example

select

      coalesce( number1, 123 ) as number1_coalesce

      , coalesce( numbertext, 123 ) as numbertext_coalesce

      , coalesce( numbernull, 123 ) as numbernull_coalesce

from

      (

            select 

                  0 as number1

                  ,'1' as numbertext

                  , null as numbernull

      ) as T1

;