I need to query rows of XML data where a specific element contains more than 1 upper case character. Sounds like a job for RegEx --- but I can't find a reference to such a function in the XPath for SQL Server 2005.
I can't create a SQLCLR function on this server, so using .NET is not an option.