|Subject||Re: Some SUBSTRING extra features?|
> Substring combined with a length UDFJust 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))
may work (not tested).
Otherwise a stored procedure that uses that logic to return the name
should be pretty easy to write.