Any help would be dearly appreciated, I'm new to xquery.
I have a procedure, that I want to query an xml in sql server 2005, problem is, I want to have parameters, where I could use the "like" operator instead of @ID=sql:variable("@id"), is there a way, where I can implement the "like" instead of the "=" operator?
Here's my whole procedure:
create procedure dbo.TestXML
SET NOCOUNT ON;
Select XML.query('/Agriculture/LandInformation/LandInfo') AS Tag
From AgricultureXML Where XML.exist('/Agriculture/LandInformation/LandInfo')=1
Thanks in advance for any help