I'm just wondering if this is intentional or not: When you go online to FileMaker's website to look up examples for Position ( Position ) and Left ( Left ) where one of the examples extracts the first name, the examples are coded differently.
If you follow Left's example (at the bottom of the Web page), it's Left(Name;Position(Name;“ “;1;1))
If you follow Position's example (at the bottom of the Web page), it's Left(Name;Position(Name;“ “;1;1)-1)
In both examples you'll isolate the first name. However, if you use Left's definition then you'll be left with a word space after the resulting name; you don't have a wordspace when using Position's definition.
I know I'm being nitpicky (I'm a Database Admin, what can I say?), but shouldn't the examples be identical, favoring Position's definition?