DataMigrator/Reporting Server > Simplified Conversion Functions > HEXTYPE: Returning the Hexadecimal View of an Input Value

HEXTYPE: Returning the Hexadecimal View of an Input Value

How to:

The HEXTYPE function returns the hexadecimal view of an input value of any data type. The result is returned as variable length alphanumeric. The alphanumeric field to which the hexidecimal value is returned must be large enough to hold two characters for each input character. The value returned depends on the running operating environment.

Syntax: How to Returning the Hexadecimal View of an Input Value 

HEXTYPE(in_value)

where:

in_value

Is an alphanumeric or integer field, constant, or expression.

Example: Returning a Hexadecimal View

HEXTYPE returns a hexidecimal view of COUNTRY_NAME. 

HEXTYPE(COUNTRY_NAME)

For Argentina, the result is 417267656E74696E61.

 WebFOCUS

Feedback