UUIDTOSTR Function [String]

Converts a unique identifier value (UUID, also known as GUID) to a string value.

Syntax

UUIDTOSTR ( uuid-expression )

Parameters

Parameters
Parameter	Description
uuid-expression	A unique identifier value.

Returns

VARCHAR

Remarks

Converts a unique identifier to a string value in the format xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, where x is a hexadecimal digit. If the binary value is not a valid unique identifier, NULL is returned.

Standards and Compatibility

SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Not supported by Adaptive Server Enterprise.

Example

To convert a unique identifier value into a readable format, execute a query similar to:

CREATE TABLE T3 (
pk uniqueidentifier primary key,c1 int);
INSERT INTO T3 (pk, c1) 
values (0x12345678123456789012123456789012, 1)
SELECT UUIDTOSTR(pk) FROM T3