6 Replies Latest reply on May 11, 2012 11:15 AM by philmodjunk

    Equals equals not equals (see description)

    Dillik

      Summary

      Equals equals not equals (see description)

      Version

      FMP 12.0v1 (and previous)

      Operating system version

      OS X 10.6.8 (and previous)

      Description of the issue

      In the data viewer or a calculation field, enter a formula as follows:
      "=" = "≠"

      That's asking, is the equals character the same as the not equals character?  FileMaker returns the result as true (1).  I haven't found any other pair of symbols that calculate as equivalent (aside from lowercase and uppercase letter pairings); why would it do it for these two?

      Expected result

      Equals should not equal not equals.

      Workaround

      Exact ( "="; "≠" ) correctly returns 0.