Hans,
Ya I know - the table that I'm using the original developer created it as a
string (his code populated the GUID as a string). So sql srvr can't convert
it back to GUID once it's a string unless the table is empty. Which then
means that i won't be able to convert the id back, etc....you get the point.
Thanks.
"Hans Kesting" <ne***********@spamgourmet.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
"Doug" <dk*******@hotmail.com> wrote in message
news:eC**************@TK2MSFTNGP11.phx.gbl... I have a value that was a GUID converted to string and stored in the DB.
I
need to get that value back into a Guid, how can i do that? Do something
like (System.Guid)<GUIDStringVariable> does not work. Thanks.
DOug
There is a constructor for Guid that accepts a string-parameter.
A different solution could be to directly store the guid
(datatype uniqueidentifier in sqlserver)
Hans Kesting