Hi

In my fieldA have various of lenth as this example;

ABCDEFG
ABCDEFG&HIJKLMNO
ABCDEFG111&HIJKLMNO

Need to split the first and second words without & as a two field.

How can i use left and mid function in this case.

-tq