UUIDTOSTR( uuid-expression )

VARCHAR

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 uniqueidentifier, NULL is returned.

This function is useful for viewing a UUID value.

• NEWID function [Miscellaneous]
• STRTOUUID function [String]
• UltraLite string functions

The following statement creates a table mytab with two columns. Column pk has a unique identifier data type, and column c1 has an integer data type. It then inserts two rows with the values 1 and 2 respectively into column c1.

CREATE TABLE mytab(
    pk UNIQUEIDENTIFIER PRIMARY KEY DEFAULT NEWID(),
    c1 INT );
INSERT INTO mytab( c1 ) values ( 1 );
INSERT INTO mytab( c1 ) values ( 2 );

Executing the following SELECT statement returns all the data in the newly created table.

SELECT * FROM mytab;

You will see a two-column, two-row table. The value displayed for column pk will be binary values.

To convert the unique identifier values into a readable format, execute the following statement:

SELECT UUIDTOSTR(pk), c1 FROM mytab;

The UUIDTOSTR function is not needed for databases created with version 9.0.2 or later.