converting to a uniqueidentifier

Hi all

In the database there is a table for customers and a table for the saleman,
the relationship between the 2 table is a uniqueidentifer field

customer table
name salesmanager
company 1 12545-854

salesmanager table
id salesmanager
12545-854 bob smith

I need to update the customer salesmanger field when someone leaves problem is that that field
is a uniqueidentifer and it will not allow me to update

Thanks in advance
rich

Can you post the exact error message you are getting when you try to update the column? A repro script that shows the problem will also be useful.|||

Hi

The error message is

Server: Msg 8169, Level 16, State 2, Line 1

Syntax error converting from a character string to uniqueidentifier

I need to be about to update the column when a new sales manager joins or change around.

Is this possible?