What is the database system? Why not solve it at the root itself? Add isnull(contact_alert_type, '') contact_alert_type in the select statement itself.
What do you think?
Aleks
ASKER
contact_alert_type is the field of the recorset. if the field value is either NULL or "" then the region won't be displayed. I am not clear what you are asking.
Nitin Sontakke
Okay...how is the recordset created? There must be a select statement somewhere if it is the kind of web applications I have been developing.
its a simple select. I will change it so that if its NULL then it will make it "" I can do that, but that was not the initial question for the IF statement.
What do you think?