Sign in
Log inSign up
Travis Horn

3.2K reads

1 comment

Jan 6, 2022

Thanks for the article.

How would one read a column that is a uniqueidentifier

example I have the following ; "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.