## Help with Substr

## Help with Substr

(OP)

I have the following function:

substr(MSG_TEST_X,1,index(MSG_TEST_X,'-') - 2)

If I change the "- 2" to "+ 2" it works, it just does not seem to work with subtracting. I have also tried the position function and the same result happens.

How can i get this to work subtracting 2 positions from where the "-" is found?

Any help appreciated.

substr(MSG_TEST_X,1,index(MSG_TEST_X,'-') - 2)

If I change the "- 2" to "+ 2" it works, it just does not seem to work with subtracting. I have also tried the position function and the same result happens.

How can i get this to work subtracting 2 positions from where the "-" is found?

Any help appreciated.

## RE: Help with Substr

## RE: Help with Substr