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
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