I am having data in xml as column in my table. I am retriveing the value
select * from customer
But my customer column value looks like this
<customer exception ="Sam"/>
<customer exception ="Jam"/>
I need to specify the first two letters of this exception in my sql reports textbox as (S,J)
How can I achieve this in SSRS reports