'myid = "1234567890"

left([myid], 8)  '12345678
right([myid], 8) '34567890