Skip to main content

Posts

Showing posts with the label Conversion failed when converting from a character string to uniqueidentifier

Convert varchar to uniqueidentifier in SQL Server

Today, I am going to share query for “ convert varchar to uniqueidentifier ” using SQL Server 2012 and solution for SQL Server error “Conversion failed when converting from a character string to uniqueidentifier”. The SQL Query:- --Convert varchar to uniqueidentifier in SQL Server. --Conversion failed when converting from a character string to uniqueidentifier. DECLARE @ProductID VARCHAR ( 50 ) SET @ProductID = 'ADC10CFC-EC8A-424B-AF5E-1F1B177D304B' SET @ProductID = ( SELECT CAST( SUBSTRING (@ProductID, 1 , 8 ) + '-' + SUBSTRING (@ProductID, 9 , 4 ) + '-' + SUBSTRING (@ProductID, 13 , 4 ) + '-' + SUBSTRING (@ProductID, 17 , 4 ) + '-' + SUBSTRING (@ProductID, 21 , 12 ) AS UNIQUEIDENTIFIER)) SELECT @ProductID
Read more