I am trying to use Free Text field in RDR1 as FMS and I am using this query:
SELECT $[SUBSTRING(T0.[Text], 1, 100)] FROM RDR1 T0
The formatted search is not working and I am not even able to access the field by Shift + F2.
Internal error (-1003) occurred [Message 131-183]