Home Forums SQL Server 7,2000 Administration Not display a text if the DB record is empty RE: Not display a text if the DB record is empty

  • May 12, 2003 at 1:42 am

    #456789

    Dalton,

    Try this:

    if not isNull(objRS("faxnr")) and objRS("faxnr") <> "" then

    Response.write "Your fax number: " & objRS("faxnr")

    end if

    Jeremy