I am new to Firebird, converting from Oracle.  Does anyone have a way to convert an integer input into a string that is 8 characters left padded with zeros if the hex value is not long enough.  In oracle I created a pl/sql function, not sure how to do this in Firebird.
 
Thanks,
  Jeremy