Search results

So, I have some data that has to be 9 digit integer, however, some of them have A or W or E at first and then 9 integers and some of them have other letters, sometimes two letter at the end of 9 digits. I tried to use accel and this command: Left([Field],9) in the update section, but it only...