bintostr

Converts a sequence of hexadecimal digits to a string of its equivalent alphanumeric characters or varbinary data.

Syntax

select bintostr(sequence of hexadecimal digits)

Parameters

Examples

Usage

  • Any invalid characters in the input results in null as the output.

  • The input must be valid varbinary data.

  • A NULL input results in NULL output.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute bintostr.

Related reference
strtobin