• Many thanks for the help.

    I ended up playing with the form of;

    SELECT * FROM dbo.F_UserXMLTable t WHERE XMLRECORD.exist(N'/row[some $t in c1/text() satisfies contains($t, "First")]') = 1

    I'm not sure this is the best way, but it does seems to satisify my needs.