I want to know that what is the difference between proper or lower?
when we must or can use Proper?
when we must or can use Lower?
I suggest you just try this out in the Data Viewer. If you don't have Advanced then make test calculation fields
Proper capitalises the first letter. lower has no capitals. Use them when you need them!
You could look at the FileMaker help for an explanation on how they work. Or if you want to read a blog then here is one: FileMaker Function of the Week: Lower, Upper, Proper
Thanks for helping.
Retrieving data ...