Hi.
I'm reading all kind of document .
We have 2008R2 server and I want to get values from nvarchar and also find values from nvarchar
let's say the table name is person , how do I get the values in fields and select the criterial from a nvarchar(but xml) field?

Let's say I have this in a field:
<person><IsInvoiced>1</IsInvoiced><PaidDate>20230523</PaidDate><town>Athens</town></person>

How do I select it?
Code:
select *
 from person
 OPENXML (person_xmlfield, '/ROOT/',1)
            WITH (IsInvoiced  varchar(10),
                  PaidDate datetime)
 where person_id = '2U61YLKV91'
 and  OPENXML (person_xmlfield, '/ROOT/',1)
            WITH (IsInvoiced  varchar(10),
                  PaidDate datetime) == ??no clue