it's easy. in delphi, you can make a udf with a function with this body:

interface

function IntToHex( var nNumber: integer ): pchar; cdecl; export;



implementation

function IntToHex( var nNumber: integer ): pchar;
begin
result := format('%1.2x',[nNumber])
end;


----------- end --------------
remember, this is only the function. you should place in your udf proyect
(delphi).

----- Original Message -----
From: "Steve Harp" <steve@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, August 03, 2005 11:58 AM
Subject: [firebird-support] UDF to provide Hexadecimal string


> Hi All,
>
> Can someone point me to a UDF that will accept an integer and return a
> hexadecimal representation as a VarChar?
>
> Thanks,
> Steve
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>