existsnode()

HI,
I have been using Oracle 10g release 2. but my current project uses SQL
SERVER 2000.
Is there any functions to tell if a node exists in the xml.In oracle we use
xmltype.existsnode(Xpathexpression).
It would be really helpful if you could reply... i am new to this...
ThanksYou can use the exist() method|||Hello markc600@.hotmail.com,

> You can use the exist() method
Umm, no, not in SQL 2000 -- not XML datatype there, need 2005 for that.
Toby, is SQL 2005 and option for you?
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||...You can use exist() method on XML type only in SQL Server 2005.
For SQL Server 2000 look at OPENXML... or upgrading to SQL Server 2005.
Best regards,
Eugene
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<markc600@.hotmail.com> wrote in message
news:1145891388.305650.227350@.i39g2000cwa.googlegroups.com...
> You can use the exist() method
>|||
Apologies for that. Fortunately someones paying attention (not me!)
Regards Mark