Le 26/06/2005 22:49, Nick Upson a dit :

> In article <42BF0EBC.7050201@...>, Philippe Makowski wrote:
>
>>select
>> *
>>from
>> T_BLANC
>>WHERE STRLEN(F_VARCHAR)=0 AND F_VARCHAR IS NOT NULL
>>
>
>
> why not use
>
> select
> *
> from
> T_BLANC
> WHERE F_VARCHAR = ''
>
> that's 2 ' characters with no space between them
>

not, because "asking for WHERE F_VARCHAR = '' doesn't work since it
will return the records that consists
of blanks only, too".