I have a query I want to return a value from a variable in a column.
I have 80910 in the column and I want a new value which is made of the first three numbers in the string.
I have coded into the Field - SCF:Left([VARIABLE],3) and when I attempt to view the query I receive an error message
"Undefined function 'Left' in expression"
What am I doing wrong?
I have 80910 in the column and I want a new value which is made of the first three numbers in the string.
I have coded into the Field - SCF:Left([VARIABLE],3) and when I attempt to view the query I receive an error message
"Undefined function 'Left' in expression"
What am I doing wrong?