I am building a search based A to Z (as it needs to run across site collections) on SharePoint 2013 and need to be able to find all pages where their 'AZText' managed property value starts with a given letter. I anticipated that I would need to use the following syntax:
However this is returning all instances where any word in that field begins with "A", not just the first word. So it returns "Apples and Oranges" but also returns "Happily Ever After".
Does anyone know if it is possible to restrict this search to the whole value of the field so that "starts with" means the whole text and not each word within that text?