Hi Sergey,

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