UUIDTOSTR function [String]

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

UUIDTOSTR ( uuid-expression )

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

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.