I have an XML file in which I am searching city's on the basis of filter containing first three characters,which is working fine.
Locations = from data in doc.Root.Elements(rs + "data")
// Get access to the child nodes using the XNamespace z
from city in data.Elements(z + "row").Attributes("CITY")
// Filter the result set
Now I want to do searching on the basis of only first and third character,second character can be anything.
How should I do it?