V4RB ... why does this SQL fail?

[Pedro fp]

Should

	WHERE WHERE fieldName = ''

work? [it does with REALdb]

Using LIKE was what I tried when = failed. However both work for the  
VVarChar field.

On Wednesday, March 12, 2003, at 04:35  AM, Ruslan Zasukhin wrote:

> So you try to select NULL values by LIKE ?
>
> This is not correct.
>
> You need use
>
>     WHERE fld IS NULL
>

Cheers, Pedro :-)

Web: <http://www.pedro.net.au>                    PGP Key ID: 387CD96F
Instant messaging...  AIM: bandidoOfOz  ICQ: 27671678  Jabber: pedrofp
                       MSN: mail at pedro.net.au           Yahoo: pedro_fp
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
~~~~~~~~~~~~~~~~~
"The worst realities of our age are manufactured realities. It is  
therefore our task, as
creative participants in the universe, to redream our world. The fact  
of possessing
imagination means that everything can be redreamed. Each reality can  
have its alternative
possibilities. Human beings are blessed with the necessity of  
transformation."
                                              Ben Okri in 'A Way of  
Being Free', 1997, p49