problem with number and char formatting..

L

leen

I'm working in Access2000 and am having trouble finding a way to take
imported "OLEPath" field values in my database and filter out or
eliminate all the alpha text so we only get numeral values, allowing
for number formatting. only the first and the last 4 of every value is
text. Here's some examples taken from a table: "A1011.bmp" or
"A201.bmp". I need to get the values to read as "1011" and "201".
Is there a way to do this with SQL Select statement or VBA(if
impossible with SQL.)


plz...i really need a help..
 
B

Brendan Reynolds

SELECT Mid$([TestText],2,Len([TestText])-5) AS Expr1
FROM tblTest;

Where 'TestText' is your field name and 'tblTest' is your table name.
 
Top