Philippe,


Philippe Makowski schrieb:

> How can I select records where a varchar field have for value an empty
> string , but not those who have for value one, two or more spaces ?
>
> For now I use :
>
> select
> *
> from
> T_BLANC
> WHERE STRLEN(F_VARCHAR)=0 AND F_VARCHAR IS NOT NULL
>
> Is there another way ?

F_VARCHAR NOT STARTING WITH ' '

worked for me.


Luc.