i'm trying to pull out email addresses info from the SSRS subscription
table.  The xml looks like this:

<ParameterValues>
    <ParameterValue>
        <Name>TO</Name>
        <Value>pep1@myemail.com;pep2@myemail.com</Value>
    </ParameterValue>
    <ParameterValue>
        <Name>BCC</Name>
        <Value>pep3@myemail.com;pep4@myemail.com</Value>
    </ParameterValue>
    <ParameterValue>
        <Name>ReplyTo</Name>
        <Value>pep5@myemail.com;pep6@myemail.com</Value>
    </ParameterValue>
    <ParameterValue>
        <Name>IncludeReport</Name>
        <Value>True</Value></ParameterValue>
    <ParameterValue>
        <Name>RenderFormat</Name>
        <Value>EXCEL</Value>
    </ParameterValue>
    <ParameterValue>
        <Name>Subject</Name>
        <Value>@ReportName was executed at @ExecutionTime</Value>
    </ParameterValue>
    <ParameterValue>
        <Name>Priority</Name>
        <Value>NORMAL</Value>
    </ParameterValue></ParameterValues>
</ParameterValues>

I have not been able to figure out the correct syntax with xpath or
xquery...my logic is as follows:

pull the 'value' data when it's sibling <Name> value = "TO"

I've done the following:

SELECT SubscriptionID, extensionSettings,
CAST(extensionSettings AS XML).value('(//ParameterValue/Value)[1]',
'varchar(max)') AS col1,
CAST(extensionSettings AS XML).value('(//ParameterValue/Value)[2]',
'varchar(max)') AS col2,
CAST(extensionSettings AS XML).value('(//ParameterValue/Value)[3]',
'varchar(max)') AS col3
from Subscriptions

which gets me the To, CC, & BCC data into output columns 1,2,3.  but I
cannot assume the 2nd value is always of 'CC' type...

I've also tried:
SELECT CAST(extensionSettings AS XML).value('(//ParameterValue[Name
="TO"]/Value)','varchar(max)') AS col1
from Subscriptions

but this generates an error about " 'value()' requires a
singleton...."

anyone provide an example of how to accomplish this?

thanks.