thetexican
New Member
I have worked out a query to search a table that contains a column of type \[code\]Xml\[/code\]. The Xml contains a tag called \[code\]<rule>\[/code\] that contains an attribute called \[code\]value\[/code\]An example of the query that I'm using is:\[code\]SELECT *FROM RulesetsWHERE Ruleset.exist('/ruleset/rule[contains(upper-case(@value), "DEFAULT")]') = 1\[/code\]I would like to be able to create a stored procedure for this query, and pass a parameter to use where the text \[code\]DEFAULT\[/code\] appears. Any ideas?Thanks!