Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Re: Difference between text and memo field


Message #1 by "Jonathan Branam" <sspeare@y...> on Mon, 13 May 2002 20:15:03
Hey,

Don't know the language exactly, but its close enough to German to get the 
meaning:

I had the same problem, with the memo field you must check for NULL.

In SQL this is the IS NULL function.

Therefore:

select * from persoon where memoveld is null

in ASP you can check with isnull(variable)

The translation may be off on a few words, but I think it answers the 
question.

> 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)

  Return to Index