> Hello,
>
> The under mentioned query outputs 1 (Firebird 3) :-
>
> select 1 from rdb$database where 'a' = 'a '

Additional to Ann's comment. If you want exact string comparison, us the
LIKE operator.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.