<div>
You can only convert it if it really is a GUID in string form. You can find out the format it must be in by running 'select convert(varchar(38),newid(<wbr />))'. If you can't express your existing string in that exact format you'll need to find another solution.
</div>


You can only convert it if it really is a GUID in string form. You can find out the format it must be in by running 'select convert(varchar(38),newid())'. If you can't express your existing string in that exact format you'll need to find another solution.

<div>
Thanks Dale - I have confirmed that it is a GUID in string form.<br />
<br />
Thanks
</div>


Thanks Dale - I have confirmed that it is a GUID in string form.

Thanks

<div>
In that case you code snippet will work.
</div>


<div>
Well maybe I spoke too soon - I still receive the error when I try this:<br />
<br />
SELECT &nbsp;CAST(src_patient_id AS UNIQUEIDENTIFIER)<br />
from ncs_conv_GENappt_recalls<br />
<br />
Msg 8169, Level 16, State 2, Line 1<br />
Conversion failed when converting from a character string to uniqueidentifier.<br />
<br />
Thoughts?
</div>


Well maybe I spoke too soon - I still receive the error when I try this:

SELECT  CAST(src_patient_id AS UNIQUEIDENTIFIER)
from ncs_conv_GENappt_recalls

Msg 8169, Level 16, State 2, Line 1
Conversion failed when converting from a character string to uniqueidentifier.

Thoughts?

<div>
<div class="content wysiwyg-content">
Hi there, I am trying to copy a column in a table to another column, but the source column is a varchar(50) and the destination column is a unique identifier. &nbsp;Of course, I routinely get the error that: <br />
Msg 8169, Level 16, State 2, Line 1<br />
Conversion failed when converting from a character string to uniqueidentifier.<br />
<br />
Can I convert this somehow?<br />
Thanks!<br />

<pre><code id="code-584362">Convert(uniqueidentifier,column_name_original)
</code></pre>
</div>
</div>


Hi there, I am trying to copy a column in a table to another column, but the source column is a varchar(50) and the destination column is a unique identifier.  Of course, I routinely get the error that: 
Msg 8169, Level 16, State 2, Line 1
Conversion failed when converting from a character string to uniqueidentifier.

Can I convert this somehow?
Thanks!

SQL Syntax - Error Converting character String to a unique Identifier

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.