Maybe use Truffler? :). I know there´s also LINQ to PageData that might be better to use for this: http://labs.episerver.com/en/Blogs/Johano/Dates/2010/6/Querying-EPiServer-PageData-using-LINQ/.
Hope this helps.
Because of database collation, perhaps? ("Aa may be treated as "Å")
I'm trying to return pages with a string property starting with a provided letter. if I provide the letter 'A' it returns correct the pages with property A that starts with letter 'A' but only if the second letter isn't also the letter 'A'. Will match on 'Andorra' but not on 'Aalborg'. Any suggestions?
string input = "Aa";
var criterias = new PropertyCriteriaCollection();
var queryCriteria = new PropertyCriteria
Condition = CompareCondition.StartsWith,
Name = "LastName",
Value = input,
Type = PropertyDataType.String,
Required = true
var pages = DataFactory.Instance.FindPagesWithCriteria(PageReference.StartPage, criterias, CurrentPage.LanguageBranch);