andieje
asked on
The data types nvarchar and uniqueidentifier are incompatible in the add operator.
Hi
How do i use a variable of type uniqueidentifier in a string concatentation
Here is my line
SET @filter = @filter + ' J.EngineerID = ''' + @engineerID + ''''
but i get this error
The data types nvarchar and uniqueidentifier are incompatible in the add operator.
thanks
andrea
How do i use a variable of type uniqueidentifier in a string concatentation
Here is my line
SET @filter = @filter + ' J.EngineerID = ''' + @engineerID + ''''
but i get this error
The data types nvarchar and uniqueidentifier are incompatible in the add operator.
thanks
andrea
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
CAST(unid as varchar)