Home Forums Programming XML Select row from non-empty node value in xml column using xml query RE: Select row from non-empty node value in xml column using xml query

  • Can you provide a sample table that has data that should not return rows as well as where you do want rows. Something like this:

    declare @t table (id int identity(1,1), xmldata xml);

    insert into @t

    values ('<x>this row returns</x>'), ('<x>this row does not return</x>');

    Russel Loski, MCSE Business Intelligence, Data Platform