> Hi Martijn

> 

> Ik had hetzelfde probleem, bij memo velden moet je checken of ze een NULL

> waarde bevatten

> in SQL de IS NULL functie.

> zoiets als dit:

> select * from persoon where memoveld is null

> in ASP kan dat trouwens met isnull(variabele)

> 

> 

> (Any chance of an English version of this please? moderator)

> 

> ----- Original Message -----

> From: "Martijn Snel" <msnel@f...>

> To: "ASP Databases" <asp_databases@p...>

> Sent: Thursday, April 12, 2001 12:37 PM

> Subject: [asp_databases] Difference between text and memo field

> 

> 

> > Hi all,

> >

> > I've got a question which I hope somebody on this list can give me a 

push

> in

> > the right direction.. here goes: I'm developing a site in which people 

can

> > register data about themselves. The data is then stored in an Access

> > database. Most fields in this database are Text-fields. Some are

> Memo-fields

> > though, as they usually contain largere discriptions.

> >

> > I've got one field where the data in the field won't always fit in a

> > text-field. So I changed the text-field to memo. This all works when

> writing

> > data to the database.. but I've got a funtion where I need to know if 

the

> > field has any data in it. So when it was a text-field I used:

> >

> > SQL="SELECT RS_persoon.RS_id, WHERE (((RS_persoon.RS_foto)<>'') ;"

> >

> > But this doesn't seem to work with Memo-fields. Is there an other way 

to

> get

> > the same result with Memo-fields?

> >

> > Thanks for your time anyway.. :-)

> >

> > Greetings,

> > Martijn

> >

> >

The reply in Dutch referenced using NULL in the WHERE clause instead of 

<>"". I would personally also include IS EMPTY in the SQL statement to 

include the instance where the MEMO field had some data entered then 

deleted. As in:

SQL="SELECT RS_persoon.RS_id, WHERE (((RS_persoon.RS_foto)IS NULL or 

((RS_persoon.RS_foto)IS EMPTY ) ;"