Don't suppose anyone knows a UDF which would allow:

select F_UNZIP(field) from table
and
update table set field = F_ZIP(:param) where ...

is there such a thing anywhere?

thanks
Alan