> Is this correct that SUBSTRING is not supported in Interbase 6?

Yes.

> In Helen's book it was said that "availability:any platform", but my
> clients who don't use firebird get syntax error :(

It's available for any platform in Firebird. In InterBase,
you'll have to use an UDF or you might be able to write a
Stored Procedure as well. I don'T have an example ready
yet though.


Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com