Hi,

buppcpp@... wrote:

>
> I know all of that, I just need an answer to my original question.
> How to format a rdb$db_key value within a literal string.

AFAIK there is no way how to do that. DB_KEY is a binary garbage. It IS
translated by ISQL to human readable form for display purposes, but it's
a special ISQL "magic". Anyway, because they are transient, there is no
point in literal string DB_KEYS. They are typically used in applications
and SP's, that have no trouble to use binding variables.

Well, I CAN imagine a way around literals with character set OCTETS or
UDF, but I CAN'T imagine any single reason to investigate further how to
do it that way. If you really need to use DB_KEY, SP or application code
is the best tool.

best regards
Pavel Cisar
IBPhoenix