Proper Case code sample
It seems Ninox does not have a proper case function. That is to say only the first letter of a sentence to be forced to Upper. The best I could come up with is:
DESCRIPTION := upper(substring(DESCRIPTION, 0, 1)) + lower(substring(DESCRIPTION, 1, 100))
Only issuse would be the 101'st letter. Of course I could replace 100 with a 1000 to cover myself but I am wondering if there is not a better way.
Of course this also does not cater for multiple sentences in a Note/Comment/Description. I could go for capitalize which is fine for names but not notes etc.
Anyone figure out a solution?