OPENXML Case Sensitive in SQL 2000

I found that OpenXML seems to be case sensitive,
it means that it cannot find match columnname if case is different.

Case-Sensitive is not good for me,  I hope to set it up to case insensitive,
is it possible? I can do it through my programming language. But want to know is it possible in SQL 2000 itself.
renjitkumarAsked:
Who is Participating?
 
James MurrellConnect With a Mentor Product SpecialistCommented:
found this
XML is case sensitive ....

you may require to include some case insensitive SGML parser in your stored
procedures.

also this may help http://www.eggheadcafe.com/conversation.aspx?messageid=29554717&threadid=29554683
0
All Courses

From novice to tech pro — start learning today.