SUBSTR AND MID FUNCTIONS IN SELECT

[Guest]

I tried to use SUBSTR and SUBSTRING in a SELECT sentence but it was not
recognized. I changed by MID MID$ LEFT LEFT$ but it still not working. The
error says "Undefined function 'MID' in expression". How can I extract a
string from a field in SELECT? Thanks.

 

[Arvin Meyer [MVP]]

MID< MID$, LEFT, LEFT$ should work. Chances are that you have a missing
reference. Open any code window, choose Tools >>> References and fix or
delte, you don't need it, the one marked missing.