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

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly