Thanks Alex,

It had not occurred to me to use Examine.

In this case I'm putting together the query for someone that is familiar with SQL but not Umbraco or Luke so I'm trying to keep it simple for them.

I've come up with the following which produces what I wanted.

select
CAST([xml] as XML) as xmldata
Into #xmlmembers
from [abc_umbraco].[dbo].[cmsContentXml]
where xml like '%nodeType="1085"%'

select
xmldata.value('(/node/@id)[1]','nvarchar(max)') as [id],
xmldata.value('(/node/@createDate)[1]','nvarchar(max)') as createDate,
xmldata.value('(/node/@nodeName)[1]','nvarchar(max)') as [name],
xmldata.value('(/node/@loginName)[1]','nvarchar(max)') as [loginName],
xmldata.value('(/node/@email)[1]','nvarchar(max)') as [email],
xmldata.value('(/node/company)[1]','nvarchar(max)') as [company]
from #xmlmembers

drop table #xmlmembers

Thanks, Matt