--- randallsell wrote:

> I have a requirement to create a unique 7 character string (numbers
> and letters).

You can use a generator for that.

> In the file-based implementation, we simply extracted
> the first 7 characters of a GUID. But I see no way to obtain a
> GUID in PSQL.

Take a look here:

http://www.firebirdfaq.org/faq98

> BTW- I can't used a Generator because these values are not internal.

I don't quite understand this. You want the engine to create them, but
they are not internal?


--
Milan Babuskov
http://fbexport.sourceforge.net