cast(
(case when t1.TEXT1G is null then ' ' else t1.text1g end)
as char(nn)) as myname