Right, Left, Mid in the script

[#1]

Hi,

I have a KeyField with the Material Number and Plant as below.

999999020-0310

How can I seperate the two Fields. The Material Number length is not fixed. it can be from 3 Digits to more than 10 or more.

I can get the Plant Number with this code

right(Field,4) as Plant

Somecombination of right() ands left() shoould give me result. Can anyone help

Thanks

Sravan

[#2]

Thanks Guys:)