Home Forums SQL Server 2005 SQL Server 2005 General Discussion Conversion failed when converting from a character string to uniqueidentifier RE: Conversion failed when converting from a character string to uniqueidentifier

  • July 28, 2010 at 9:35 am

    #1199314

    DECLARE @TABLE AS TABLE(

    id UNIQUEIDENTIFIER)

    INSERT INTO @TABLE

    SELECT Newid()

    SELECT *

    FROM @TABLE

    WHERE CONVERT(VARCHAR(255), id) = 'd65cafc-1435-45d3-acce-dc464f02c4b1'

    How's that?

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/