• Select COALESCE(T1.State, 'String') as state

    from table1 as T1