SUBSTR AND MID FUNCTIONS IN SELECT

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top