I am using FMP 9. I have a text field that is normally all caps. I uploaded some data that contained a combination of caps and non-caps.
The text field is used for months. Therefore, is "JANUARY" equal to "January" and/or "january"?
I know its a simple question, but I have several thousand records that will need to be fixed if they are not equal.
Thanks in advanced