Originally Posted 6 July 2011, 1:36 am ESTWithin the schema Designer, I am trying to create a calculated field in a table using the string function left without success.
The calculation expression I am trying to create is : left([field1],2)
I get the "invalid variable left" message.
Can you use these type of functions in the calculate expression? Is there an alternate way to achieve the same?