Hi

My mistake I missed some info out of my previous example.

SELECT T1.ADID, T1.COUNTRY, ISNULL(T1.STATE,'the text you want instead of NULL')

FROM yourtable AS T1