Search code examples
sqlintersystems-cache

Does Intersystems Caché has "mid" function?

I would like to know if there is "mid" function on Intersystems Caché Database. I'm trying to use it to solve a problem here, where I need to read a string of any size from the 8th character and I'm receiving the following error:

    Error: General error
    SQLState:  S1000
    ErrorCode: 0

Thank you all.

Solution

  • You're looking for $EXTRACT.

    You can find documentation here.