NULL value and login

[jsteinmann]

snippet of code you need to look at... elseif session('firstname') <> '' and
session('lastName') <> '' and expire => date() and ip = '' or ip =
Request.ServerVariables('REMOTE_HOST') THEN response.redirect
'members/index.asp' basically, i want to limit the access by username,
password, expiration, and ip address (and i'm passing several session varialbes
as you could tell), however, not all records have ip addresses stored in the
SQL DB. to prevent any problems with logins, but to add this IP restriction
feature, i want the login to allow redirect to the index page even if the ip
value is = NULL in the SQL database. i've tried saying NULL, i've tried empty
quotes (like you see above), i've tried 0... none of it works. anyone know the
answer?

[jsteinmann]

allowing DB value NULL