Subject Select on varchar with spaces
Author Philippe Makowski
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 ?