This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
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
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".
''9UIC32D1-932-4V03-45E9-FGSGDASASDATY'')
A GUID can have numbers and letters between A-F, but never T or Y; your GUID is invalid.
What is the solution how to convert it in gu id
There is no other solution then get a valid GUID.
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.
how to get this guid
Your "GUID": 9UIC32D1-932-4V03-45E9-FGSGDASASDATY
A real GUID: B6DFBCC9-27A2-4CF8-806A-8797DB9F4CDA
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.