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 ?