<div>
What is the database system? Why not solve it at the root itself? Add isnull(contact_alert_type,<wbr /> '') contact_alert_type in the select statement itself.<br />
<br />
What do you think?
</div>


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?

<div>
contact_alert_type &nbsp;is the field of the recorset. if the field value is either NULL or &quot;&quot;&nbsp; then the region won't be displayed. I am not clear what you are asking.
</div>


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.

<div>
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.
</div>


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.

<div>
its a simple select. I will change it so that if its NULL then it will make it &quot;&quot;&nbsp; I can do that, but that was not the initial question for the IF statement.
</div>


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.

<div>
Thanks. This is what I needed.
</div>


<div>
<div class="content wysiwyg-content">
I have the following code which will display a region if a recordset field is not = &quot;&quot;&nbsp; (blank)<br />
I need to add to it that is also NOT null.<br />
<br />

<pre><code id="code-10-29013912-1">&lt;% If rs_contactalert.Fields.Item(&quot;contact_alert_type&quot;).Value &lt;&gt; &quot;&quot;  Then 'script %&gt;

REGION

 &lt;% End If %&gt;   </code></pre>
</div>
</div>


I have the following code which will display a region if a recordset field is not = ""  (blank)
I need to add to it that is also NOT null.

(CODE)

Display if field is NOT &quot;&quot; or NOT null

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.

Display if field is NOT &quot;&quot; or NOT null

Display if field is NOT "" or NOT null