If you're only interested in the X portion of the budget period, I would just create an additional property for storing the period, and index that separately as part of your product content.
Then you can just perform an OrderBy on that specific property.
This was exaclty what I came up with the second I was going to bed yesterday, after sitting with this issue the entire day trying to force out a solution at the sorting it came to me, as always when you stop thinking about it.
Was looking at it from the wrong direction.
Always the way isnt it! :D
I would like to sort/boost some products to the top on my searchresult, I have a parameter on the products with budget period, yyyyx (where yyyy is budget year and x is 1 or 2 (first or second half of the year)).
So we can set a dropdown to: 0, 1, 2 and based on that value I want to sort/boost the result from find to that selected value.
I need to compare the selected valute to the last character of the property in find.