Hi,

At June 27, 2005, 04:30, Kjell Rilbe wrote:

> Lucas Franzen wrote:

>> 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.

> Is that

> a) a bug,
> b) a weird "feature" in Firebird, or
> c) a weird "feature" in the SQL standard?

SQL Standard, for quite a number of years(maybe over 10-15 years). The
trailing blanks in a VARCHAR are stripped when using the "="
comparison.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)