> Substring combined with a length UDF

Just to add to Alexandre's tip:

ib_udf.dll/so (ships with all Firebird installs) has a strlen function.

select substring(somefield from 1 for (strlen(somefield)-3))
from sometable

may work (not tested).
Otherwise a stored procedure that uses that logic to return the name
should be pretty easy to write.

Adam