[thelist] Testing for the various NULL's

Jason Handby jasonh at pavilion.co.uk
Thu Dec 5 12:03:01 CST 2002


Hi Rob,


In VBScript, any comparison operator ( =, <>, etc.) will evaluate to Null
when used with a Null value -- and Null is treated as False for the purposes
of if statements, etc.  To test whether a variable contains a NULL value,
use the isnull() function, eg:

	if not(isnull(myvar)) then
		'blah blah
	end if


Hope this helps!




Jason




More information about the thelist mailing list