Convert GUID to varchar(32)

sql sql-server ssms guid varchar
Jfabs picture Jfabs · Apr 25, 2013 · Viewed 42.7k times · Source

How can I convert a GUID which is 36 characters to a VARCHAR(32)?

I'm trying to copy data from one table to another. There are two similar columns from these two tables.

  1. Table1.colx is a GUID so it is 36 characters in length in total due to the hyphens
  2. The corresponding column is table2.colx but it is a VARCHAR(32)

I am looking for a way to convert a GUID to VARCHAR, but I've got to remove the hyphens. So far I have been unsuccessful in my attempts to find a way to do this.

Answer

Esoteric Screen Name picture Esoteric Screen Name · Apr 25, 2013

I assume this is SQL Server, from the SSMS tag.

Convert the GUID to a string, then replace the hyphens with empty strings:

REPLACE(CAST(table1.colx AS VARCHAR(36)),'-','')

Related questions

How do I set a column value to NULL in SQL Server Management Studio?

How do I clear the value from a cell and make it NULL?

Read More
Insert Data Into Temp Table with Query

I have an existing query that outputs current data, and I would like to insert it into a Temp table, but am having some issues doing so. Would anybody have some insight on how to do this? Here is an …

Read More
SQL Server 2008: how do I grant privileges to a username?

I need to be able to establish an ODBC connection through SQL Server authentication. In SSMS how do I grant permission for a user to be able to have ALL RIGHTS on a specific database? is there a way to …

Read More