UUIDTOSTR function [String]

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

NEWIDuuid-expression )

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

SELECT UUIDTOSTR(uid_col),c1 FROM mytab

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.