Subject Re: [firebird-support] Select on varchar with spaces
Author Lucas Franzen
> 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.