Hi asranantha, 😀

I would use COALESCE AND CASE, because it's SQL standard.

SELECT CASE COALESCE(your_column,'NA') WHEN '' THEN 'NA' ELSE your_column END

Hope it helps. 😎