how to replace the null value with charecter value('no data") and how to identify which column having the null value this code write in procedure

Question

i have one table conntryname, statename in both column i inserted values through procedure but i want identify which column having the null value and that value is replace by 'no data'

// i want the code in procedure only//