I am using SQL 2000. NTEXT is the data type that I used for my new column in my table.

>Are you using SQL 2005? What is the type of the column with XML?
>
>>
>>I have added a column in my table that has xml string in it and now I wanted to parse/pick the value_out in the xml string if value_in is given in the table.
>>
>>Thanks,
>>Sam
>>
>>>What it has to do with SQL Server?
>>>
>>>>I need to pick the value_out in the XML string if value_in is given. Please help.
>>>>
>>>>

>>>><Salutation>
>>>>  <Mapping>
>>>>    <value_in>1</value_in>
>>>>    <value_out>Mr</value_out>
>>>>    . . .
>>>>  </Mapping>
>>>></Salutation
>>>>

>>>>
>>>>Thanks,
>>>>Sam