Using MSSQL with Classic ASP

Thanks for the article.

How would one read a column that is a uniqueidentifier

example I have the following ;

objRS.open "select * from [dbo].[tblSMSVerify] where UID = '"& xUID &"' AND SMSGenned = '"& smscode &"'",connObj,2,3,1

UID is a uniqueidentifier column in mssql xUID is a GUID

however I am getting a message as follows ;

Conversion failed when converting from a character string to uniqueidentifier.

Cheers