| Subject | Select on varchar with spaces | 
|---|---|
| Author | Philippe Makowski | 
| Post date | 2005-06-26T20:23:24Z | 
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 ?
            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 ?