Ok

So I've visited a few other websites in search of my answer but to no avail.

Can you use the Len() function in an SQL statement??

For instance What I want to do would look something like this

SELECT * FROM [Table] WHERE Length [Database Field] = 0

Analysis:

I would like an SQL statement that will allow we to display all records where a specific field has no entry or is a zero length string or has a null entry.  Testing the length is the way I believe I should go, but as always any suggestions as to the solution to this problem would be most appreciated.

Regards

Shady

____________________________
I don't wanna die... but I ain't keen on livin' either

My reply to your post is at:

http://www.andreavb.com/forum/viewtopic.php?TopicID=638