XML "field" exists not '"data" ???

• jbalbo

  SSCertifiable

  Points: 7583

  More actions

  July 20, 2022 at 2:34 pm

  #4066011

  Hi ,

  I have a query where it picks up multiple lines for an table with XML data based on the form

  The table does have a form number so I could use that to get the correct occurance of the table, but was thinking what if a new form is developed giving a new number. So, the question is can I use a where clause on if the field exists?

  Field is called "Type" so something like (I know the expression is wrong)    where  data.field( '/Data/Type)[1]') = 1 ?

   

  Thanks

   

   

   

• jbalbo

  SSCertifiable

  Points: 7583

  More actions

  July 20, 2022 at 2:41 pm

  #4066012

  So I figured out a work around using

  and Data.value('(/Data/Type)[1]', 'nvarchar(100)') is not null

   

  but if anyone else knows another option, always good to know...