Kirill Bondar 3/23/2012 8:04:16 AM
While examining existing formulas for [Not]Left/Right calls I found quite common pattern:
Right([Column], Len([Column]) - 1)
to get all the characters except the first one, mainly in the context of capitalizing first letter. Instead of Right() you can use NotLeft([Column], 1) that will do exactly the same, but this way you can get rid of Len() call.
Generally, if N does not exceed text length, the following is true:
[Column] = Left([Column], N) & NotLeft([Column], N)
Thus to capitalize first letter you can use
Upper(Left([Column], 1)) & Lower(NotLeft([Column], 1))