I have a name attribute that is being entered as FIRST NAME and then LASTNAME. I want to pull out the first name as a calculated column on a query. So I have the expression entered as:
WORDS_FROM_LEFT (CaseMaster.CaseAssistant.FullName,1)
When I run the query I get the following:
Internal error. Invalid calculated column expression WORDS_FROM_LEFT (CaseMaster.CaseAssistant.FullName,1)
The same thing happens if I try WORDS_FROM_RIGHT.
But, if I use CHARS_FROM_LEFT(CaseMaster.CaseAssistant.FullName,10) or something similar it works just fine.
Can we not use WORDS_FROM_??? in a calculated column?
Jim
