Split customer code for FMS autonumbering
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!
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.