[SQL] parsing a string with a hexadecimal notation

[KÖPFERL Robert]

I intend to retrieve an int value in an integer variable from a string with
a hexadecimal notation of a number.
Which function is appropriate to  do 
 i int4 
i = ???('BEAF')

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]