HEX_DECODE_STRING

Learn how to use the HEX_DECODE_STRING string function in PlaidCloud Lakehouse. Decodes a hexadecimal string to a VARCHAR string - with syntax and examples.

Decodes a hexadecimal string to a VARCHAR string.

Analyze Syntax

func.hex_decode_string(<hex_str>)

Analyze Examples

func.hex_decode_string('48656C6C6F')

┌─────────┐
│ 'Hello'  │
└─────────┘

SQL Syntax

HEX_DECODE_STRING(<hex_str>)

SQL Examples

SELECT HEX_DECODE_STRING('48656C6C6F');

┌───────┐
│ Hello  │
└───────┘