find an empty cell

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • colinod
    Contributor
    • Nov 2007
    • 347

    find an empty cell

    I have the following to determine unused parts of a database and was wondering how to find it if the cell is just empty instead of having the word unused in it

    Code:
    <%
    if InStr(localRecordset("station3"),"unused") > 0 then %>
  • AricC
    Recognized Expert Top Contributor
    • Oct 2006
    • 1885

    #2
    Empty cells in your DB should have NULL values not "unused" if you want to test for a null in asp use the IsNull() function

    Comment

    Working...