Hi there.

I can not working this CONCAT Function:

Code:
CONCAT
   (
      SUBSTRING_INDEX(`ab00-1-380216`,'-',1)
    , SUBSTRING_INDEX(REVERSE(`ab00-1-380216`),'-',1)
   )
The input: ab00-1-380216
The output correct: ab00138216

I have this output incorrect: ab00612083

Can u help me?