Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Converting & working with (GUID) uniqueidentifier

Author  Topic  huge Starting Member 31 Posts Posted - 2001-08-07 : 14:35:07 Ok I have an asp page that assigns sessions to each user by a GUID. I keep getting problems saying Syntax error converting from a character string to uniqueidentifier. So is there a way to convert a character to a uniqueidentifier? in asp there are many conversions but none deal with the GUID character. Is there such a thing with SQL server that I can plug into my sproc? Thanks for any help Mike M