append question

[Guest]

on a file that i am uploading to my database, it has many rows of data. Each
row begins will about 8 digits. I made a query that will take the first 4
number of that 8 digits, and if row 1 4 numbers are equal to row 2 4 numbers
then it groups them together and combine the total amount, from the TOTAL
AMOUNT column.
I figured that one out,
but now i have a problem, sometimes the 8 digits are 7 instead of eight
I dot' want to it taking the first 4 numbers if it only 7 digits, only the
first 3 digits.
Need help with this

for instance
78011212 = 7801
78011213 = 7801
7801232 = 780

 

[Guest]

IIF(Len(Num)=8, Left(Trim(Num),4), Left(Trim(Num),3))