unable to convert unique identifier

Vineet S 1,070

Hi Team,

unable to convert this value as an unique identifier and getting null values

SELECT try_convert(uniqueidentifier,''9UIC32D1-932-4V03-45E9-FGSGDASASDATY'')testid

2 answers

LiHongMSFT-4306 27,961 Reputation points

2024-06-12T07:53:10.2466667+00:00

Hi @Vineet S

Because the value is not valid GUID type. TRY_CONVERT returns NULL when the convert fail.

Best regards,

Cosmog Hong

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Olaf Helper 45,101 Reputation points

2024-06-12T07:59:06.7766667+00:00

''9UIC32D1-932-4V03-45E9-FGSGDASASDATY'')

A GUID can have numbers and letters between A-F, but never T or Y; your GUID is invalid.
Please sign in to rate this answer.
Vineet S 1,070 Reputation points

2024-06-12T08:14:47.0266667+00:00

What is the solution how to convert it in gu id

Olaf Helper 45,101 Reputation points

2024-06-12T09:40:23.4966667+00:00

There is no other solution then get a valid GUID.

Erland Sommarskog 112.7K Reputation points MVP

2024-06-12T21:50:44.3166667+00:00

In addition to what Olaf said, look at this:

Your "GUID": 9UIC32D1-932-4V03-45E9-FGSGDASASDATY A real GUID: B6DFBCC9-27A2-4CF8-806A-8797DB9F4CDA

You may note that your value is group differently from the string representation of a real GUID.

In case you don't know: A GUID is a 16-byte value. It is commonly represented as a string value with 32 hex digits and some hyphen thrown into fixed places.

I don't know what you have, but if you think it is a representation of a GUID, you need to talk with someone who gave you the data to find out how to interpret the string. But since there are letters from all over the alphabet, this seems to be a lot more than 16 bytes.

Vineet S 1,070 Reputation points

2024-06-13T08:08:28.31+00:00

how to get this guid

Your "GUID": 9UIC32D1-932-4V03-45E9-FGSGDASASDATY

A real GUID: B6DFBCC9-27A2-4CF8-806A-8797DB9F4CDA

Erland Sommarskog 112.7K Reputation points MVP

2024-06-13T08:27:50.7633333+00:00

how to get this guid

What do you mean with this question? Your string is not a GUID, or at least not a GUID with a format that we know of.

I got my sample GUID by using the newid() function, but I could just as well taken one from the Windows registry or any other place where there are GUIDs.

Maybe you should give us some context how you get hold of this GUID-sort-of-lookalike? Maybe then we could come up with some advice of what you should do.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

unable to convert unique identifier

2 answers

Your answer