TO_VARBYTE function - AWS Clean Rooms
SyntaxArgumentsReturn typeExamples

TO_VARBYTE function

TO_VARBYTE converts a string in a specified format to a binary value.

Syntax

TO_VARBYTE(string, format)

Arguments

string

A CHAR or VARCHAR string.

format

The format of the input string. Case insensitive valid values are hex, binary, utf-8, and utf8.

Return type

VARBYTE

Example

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

SELECT TO_VARBYTE('6162', 'hex');
               
+------------+
| to_varbyte |
+------------+
|       6162 |
+------------+