Sql query, selection by unique identifier gives - Error converting varchar data type to uniqueidentifier

Question

How to select a column of type uniqueidentifier when I have a pointer?

I tried to do the following:

SELECT * FROM MyTable WHERE id = '442402e-207d-b012-4b60-005056c00123' and SELECT * FROM MyTable WHERE id = '{442402e-207d-b012-4b60-005056c00123}' 

Both give me the same error: Error converting varchar data type to uniqueidentifier.

Answer 1

The first request is fine, but there is no digit in the first part of the GUID, it should contain 8 digits, not seven .... something like this:

 SELECT * FROM MyTable WHERE id = '71494DD6-90FB-417D-B9E2-28F34103C039' 

Answer 2

The first section is missing a number

4067876A-E3C3-4A3D-B2D3-E879474168C6 - valid GUID
442402e-207d-b012-4b60-005056c00123 not