Helen,

> >While we're on the subject, I thought that substr was an internal
> >function in Firebird RC1.
> >Is that true? I can't seem to be able to use it (the parser rejects it).
>
> No, it's not true. The internal function is SUBSTRING (see the release notes for syntax). the SUBSTR udf in ib_udf was fixed up, too.

A-ha. Thanks!
BTW, it seem to work well with distinct. Do you say

select distinct substring(field from 1 for 10)

should throw an error? If so, why?
Ciao
--
____
_/\/ando