How should i get the Xpath.?

Sorry...

have two tables..one is ProductBase and other one is ProductGroup...

I need to make a join between ProductId of Producttable(Primary key) and ProductID which is xml datatype

Please help me

I...

Thanks for ur response...

but when i tried that code...i am getting the following error

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'list'.

Msg 156, Level 15, State...

Thanks alot Jhon...it is working nw.....

thanks again

still iam getting the same error

thanks for your quick response

i have to update CrossSell field of productbase table ,the CrossSell field is a xml data type which contains null value

i inserted values in a different table using clr...

in my ProductBase table the CrossSell field contains null value