views:

86

answers:

0

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