Posted by Mike R on 03/09/06 19:50

I didnt think so, I will check again

Kind Regards

Mike

"Jack Vamvas" <delete_this_bit_jack@ciquery.com_delete> wrote in message
news:dupl5k$8n1$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...
> Is it possible that you have an unacceptable character in the string? That
> will not allow it to convert into a uniqueidentifier
> Must be in the range 0-9 or a-f
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
>
>
> "Mike R" <noreturnaddress@hotmail.co.uk> wrote in message
> news:dupk91$otg$1$8302bc10@news.demon.co.uk...
>> Hi,
>>
>> I have this simple bit of SQL
>>
>> UPDATE A
>> SET a.owninguser = c.companyname
>> --select a.owninguser,c.companyname
>> from campaignresponsebase c
>> inner join activitypointerbase a on a.activityid = c.activityid
>> WHERE Companyname is not null
>>
>> Companyname contains a string which happens to be a guid. Owninguser is a
>> guid.
>>
>> I keep getting
>>
>> Server: Msg 8169, Level 16, State 2, Line 1
>> Syntax error converting from a character string to uniqueidentifier.
>>
>> When I run this, I have also tried CAST(c.companyname as
>> uniqueidentifier)
>> and still get the same.
>>
>> Any pointers?
>>
>> Thanks
>>
>> Mike
>>
>>
>
>

[Back to original message]