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