Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# FROM\$1HEX function
<a name="r_FROM_HEX"></a>

FROM\$1HEX converts a hexadecimal to a binary value. 

## Syntax
<a name="r_FROM_HEX-synopsis"></a>

```
FROM_HEX(hex_string)
```

## Arguments
<a name="r_FROM_HEX-arguments"></a>

 *hex\$1string*   
Hexadecimal string of data type `VARCHAR` or `TEXT` to be converted. The format must be a literal value. 

## Return type
<a name="r_FROM_HEX-return-type"></a>

`VARBYTE`

## Examples
<a name="r_FROM_HEX-examples"></a>

To convert the hexadecimal representation of `'6162'` to a binary value, use the following example. The result is automatically shown as the hexadecimal representation of the binary value.

```
SELECT FROM_HEX('6162');
               
+----------+
| from_hex |
+----------+
|     6162 |
+----------+
```