SQL Server: converting UniqueIdentifier to string in a case statement
SELECT CONVERT(NVARCHAR(36), NEWID());