Truncating

Question: We are on BW 3.1C and R/3 4.7. I am tasked with combing R/3 and Legacy data in an ODS. The first four characters in the material number are the same, but after that they are different. We would like to combine at the four character level. Can anyone give me a routine to truncate all after the first four?
Thanks i advance

Answer:
result = comm-structure-xxxx(4).

where xxxx is the material field name.

Answer:
Thank You for the help, I was having serious brain fade after the three day weekend
Copyright ?2007 - 2008 www.jt77.com