HEX( ) function

Returns a hexadecimal string representing the contents of the specified value.

Syntax

HEX(field)

Parameters

field

The value to display the contents of in hexadecimal format.

Output

Character.

Remarks

This function returns the hexadecimal string that is equivalent to the field value or expression you specify. You can use the function when you need to identify the exact contents of a field, including characters that cannot be displayed on screen.

The return value is a string that is double the length of the field parameter. The digits 0 to 9 and the letters A to F (for the digits 10 to 15) represent the 16 hexadecimal values.

In general, you should apply this function to fields rather than expressions because it displays a representation of the internal storage format of expressions, which is not meaningful in most instances.

Examples

To find the hex value of field X that contains the string 12345:

HEX(X)

returns "3132333435".

To add a field to your view that is the hex value of the Count field, specify:

HEX(Count)

Related reference
BIT( ) function


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback