Classic ASP Discussion - Check for empty DB field

Print Page | Close Window

Check for empty DB field

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=1963
Printed Date: 29 March 2026 at 11:32am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Check for empty DB field

Posted By: Dazz
Subject: Check for empty DB field
Date Posted: 21 April 2003 at 8:45am

How can i check if a database field is empty ?

Replies:

Posted By: Bunce
Date Posted: 21 April 2003 at 10:12pm

Depends what you mean by empty. NULL and empty are different.

To test for NULL: If Field IS NULL
To test for blank: If Field = "" or If LEN(Field) = 0

Cheers,
Andrew

-------------
There have been many, many posts made throughout the world...
This was one of them.