Category: ASE: Functions: Datatype Conversion Functions

bintostr()

The Datatype Conversion Function bintostr() converts the datatypes binary and varbinary to varchar(255). bintostr() is an undocumented Sybase® Function. It can be used starting with ASE® 12.0.

Syntax of the datatype conversion function bintostr()

    bintostr( binary_value )
    

The parameter of the datatype conversion function bintostr()

binary_value
The parameter "binary_value" is a placeholder for a binary value. The return value is displayed without the prefix "0x".

Example for the datatype conversion function bintostr()

    select bintostr(0x1A0F)

    go

    -----

    1a0f
    

See also:

ASE T-SQL - Aggregate Functions,
biginttohex(),
cast(),
convert(),
Datatype Conversion Functions,
explicit conversion,
hextobigint(),
hextoint(),
implicit conversions,
inttohex().