MS-ACCESS Select substring
Posted on 2003-11-03
I'm working on a a critical report and I was forced to used MS-ACCESS over ORACLE. Now I'm stuck with a basic select statement. Anyway, to make a long story short, I want to select the first two digits of a column in access -- how can I do this. For eg, the column always contains a 4 character field like 4443 (this is not a number). All I want to do is select the first two characters, in this case '44'. Any ideas? Please this is an urgent call -- I've attached 200 points to this question. Thanks for your time and help!!