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
 General SQL Server Forums
 New to SQL Server Programming
 Comparing hst_name() with uniqueidentifier

Author  Topic 

lonifasiko
Starting Member

11 Posts

Posted - 2005-10-04 : 03:59:07
I'm using HOST_NAME() function in a Merge Replication scenario. My problem is that I must compare the nvarchar this function returns with a uniqueidentifier column.

"patientID" is my uniqueidentifier column and I must compare it to HOST_NAME() function.

------------
MIGUELÓN

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-10-04 : 04:24:05
where HOST_NAME() = convert(nvarchar(100), patientId)

Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -