How to force a string to sort to bottom in Crystal Reports?

I could have sworn that Crystal Reports u开发者_Go百科sed to sort strings beginning with a space to the bottom. For example, the strings " Amsterdam", "Belfast", and "Cancun" would be sorted as:

Belfast
Cancun
 Amsterdam

This thread seems to confirm that.

However, now I'm using CR 2008 SP3 and it's being sorted to the top, as:

 Amsterdam
Belfast
Cancun

I have tried all sorts of special and control characters and everything is sorting to the top. What am I missing?

How about inserting another sorting level, using a formula CitySort:

If {City} = " Amsterdam" Then 1 Else 0