SQL statement for converting uniqueidentifier to varchar Data Type

For more information about how to convert a uniqueidentifier to a varchar SQL statement, see.

For more information about how to convert a uniqueidentifier to a varchar SQL statement, see.

The Code is as follows:
--- Tu juwen Geovin Du
DECLARE @ myid uniqueidentifier
SET @ myid = NEWID ()
Select convert (char (255), @ myid) AS 'Char ';
GO
-- Tu juwen Geovin Du
Declare @ allstring char (255), @ AreaUid Uniqueidentifier
Set @ AreaUid = '37a1da94-4AC6-4ED0-B96F-BA3FE6AEACC8'
Set @ allstring = cast (@ AreaUid as char (255 ))
Select @ allstring
-- Tu juwen Geovin Du
Declare @ allstring char (255), @ AreaUid Uniqueidentifier, @ s varchar (200)
Set @ AreaUid = '37a1da94-4AC6-4ED0-B96F-BA3FE6AEACC8'
Set @ allstring = CONVERT (char (255), @ AreaUid)
Set @ s = cast (@ allstring as varchar (200 ))
Select @ allstring, @ s
-- Tu juwen Geovin Du
Declare @ allstring char (255), @ AreaUid Uniqueidentifier, @ s varchar (200)
Set @ AreaUid = '37a1da94-4AC6-4ED0-B96F-BA3FE6AEACC8'
Select @ s = CONVERT (varchar (200), cast (@ AreaUid as char (225 )))
Select @ s