Viewing post 1 (of 2 total)
Try using the XPath test function. This seems to work:
Select * from OPENXML(@idoc,'/MiscInfoResponse/PropertyDetail/Description/DescLine',3)
WITH (LineNumber int '@d' ,
Description varchar(8000) 'text()'
)
HTH - Nigel
January 24, 2003 at 9:21 am
#447158