how to read this funy access type

[henryhandle]

I have this colum, ordernumber
(type is Text) with values like this:
\_\14053
11115
\_\14092
1010
if i read with select ordernumber from ordertable
I get a data type error !
How could be for example only the 14053 read?
Thanks for your advance

 

[PHV]

With a recent version of access (xp or above):
SELECT Replace(Replace([ordernumber],'\',''),'_','') As [Order#]
FROM ordertable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[henryhandle]

thanks for your hints, but i use accesss 2002
I becomm with your Command undefined function Replace error
from the microsoft odbc driver

 

[PHV]

from the microsoft odbc driver
What is the underlaying database ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[henryhandle]

>What is the underlaying database ?
ERROR: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Undefined Funktion 'Replace'

 

[PHV]

java.sql.SQLException
How is this error related to Microsoft: Access Forms ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[henryhandle]

i read data via a servlet from access database!