SQL Function rawtohex()

[nancyphilips]

Is there any function called as rawtohex( ) in SQL? If so can someone give me the syntax and usage of this function? If possible an example on this would help us to have a better idea about this function.

[Bessie]

RAWTOHEX converts raw data type to a character value containing its hexadecimal equivalent. The syntax is

select RAWTOHEX(raw data type column) "Sample" from tablename;

Here the hexadecimal equivalent of a RAW column value is returned.