Convert varchar to uniqueidentifier in SQL Server

This post shows you How to Convert varchar to uniqueidentifier in SQL Server.

For example:

a79b1ecd95015ae6b9c8aabb07da1020

To convert varchar to uniqueidentifier  you can use the sql query as shown below.

SELECT CONVERT(uniqueidentifier,STUFF(STUFF(STUFF(STUFF('a79b1ecd95015ae6b9c8aabb07da1020',9,0,'-'),14,0,'-'),19,0,'-'),24,0,'-'))

Result

A79B1ECD-9501-5AE6-B9C8-AABB07DA1020