Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Split customer code for FMS autonumbering

Hi all,

We are using customer codes like 0134K and 3456L. Now I'm building a FMS for autonumbering the customers when adding one. Now I want to split the code in '0134' and 'K'.

Can anybody help me?

Thanks in advance!

Greetz

Lars

replied

Hi Lars

Try the following:

SELECT LEFT(T0.Cardcode, 4) - Will return just the first 4 characters.

SELECT RIGHT(T0.CardCode, 1) - Will return only the last character.

Kind regards

Peter Juby

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question