Mac OS X 10.5.6
This is not a bug. It is expected FileMaker behavior.
As a number here are some of the different scenarios pan out.
"ASDF1-AS YYYY1" 11
That is why when you save just SS-######### it will sort to the top.
Thanks for the quick answer.
Well that's nice that the expected behavior is based off Social Security number use. Pretty much an arbitrary decision. I would suggest strongly that a click box to turn off this feature be added to the next release. Unless of course Filemaker was made just for Social Security Administration. You can see by my example how that is not user friendly. I wonder how many more hidden gems like this haunt Filemaker. Does Filemaker sell different versions to different countries based on Government Policies? Smells like boutique software. Do you understand what I am saying? It is an arbitrary decision that could just as easily been handled by each application engineer. IT'S AN EXCEPTION TO THE RULE! Which means it is not intuitive or user friendly. I don't know how Filemaker's Usability Group let that one through. BTW, SM-0001 numbers also migrated to the top, I guess its keying off the 1st character being S.
By your example there is no simple way to sort a combination of alphanumeric fields, if you make it text you get 1, 10, 100. If you make a number then you get the SS1-1 11 feature.
I think you have missed the point here...
FileMaker is forgiving for the most part of what is entered into a text field or number field, whereas other DBs are strict with thte data types.
So, if your field is a number field, upon an evaluation it will ignore the alpha characters...However the dash is special since it can indicate a negative number...
Therefore if a dash is IN FRONT of a number, then it will treat it as a negative number. However, if the dash comes AFTER a number, it will assume a possitive? Does this clear things up?
John (Mr. Vodka) is correct: this is not a bug, but a result of entering text into a Number field. You should store your serial "numbers" in a Text field, and define a calculation field for sorting purposes (since you obviously don't want the alphabetical sorting applied to Text).
The exact calculation depends on how you actually want your data to be ordered - something you neglected to mention.