Syntax for converting a string from UPPER case to Proper case?
Is there a way to convert UPPER case to Proper case?
0
-
You mean to convert a field value to ‘proper’ case? I don't think there is a direct way to do this, but this may be a workaround:
Upper(Substring([myfield], 0, 1)) + Lower(Substring([myfield], 1))
0 -
Berend Veldkamp Thank you so much!! This syntax worked for fields with one word, which is great! Any ideas on how to adjust for fields with more than one word? ie: SILVER LAKE to Silver Lake
0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
2 kommentarer