xquery - dynamic field name

[DD77]

i need to query an xml field, but the node name i am looking for is not constant and needs to be taken out of join result.
i was trying to do something like this but it does not work:
select ref.value(ref.query('sql:column("B.FieldName")'),' varchar(100)')
from TableA A
cross apply xmlField.nodes('NodeP/NodeG') R(ref)
inner join TableB B
on A.ID = B.ID

any suggestions as for how to make the field name in the ref.value be dynamic? and not via variable cause i need it on multiple records.
thanks!

[ck9663]

You might need to build a dynamic query on this one...

-- CK

[DD77]

You might need to build a dynamic query on this one...

-- CK

i did buit a dynamic query but i keep getting an error that ref.value must get a literal string as the node name, and cannot get a dynamic \ fieldname as the node name :(
any idea how to overcome it?

[ck9663]

What do you have so far?

-- CK