Hi
 
try the following code:
 
create exception test 'Blank';
set term ^;
create OR alter procedure p_test
as
begin
  IF (' ' = '') THEN
    exception test;
end^
set term ;^
execute procedure p_test;
 
Upon execution the exception is raised. So Firebird is saying that a blank is the same as no blank.
We are not talking about trimming of chars or varchars here. These are constants. Surely this can't be the desired outcome...

[Non-text portions of this message have been removed]