Subject | Re: [firebird-support] Select on varchar with spaces |
---|---|
Author | Lucas Franzen |
Post date | 2005-06-26T21:04:51Z |
> F_VARCHAR NOT STARTING WITH ' 'sorry, this won't work for data like 'this' :-(
So
F_VARCHAR NOT STARTING WITH ' ' AND
F_VARCHAR = ''
should work
Simply asking for WHERE F_VARCHAR = '' doesn't work (as you found out on
your own as I suspect), since it will return the records that consists
of blanks only, too.
Luc.