converting an oracle query to access

[markyb]

I currently have a query that i run against an oracle DB that works fine, i would like to rewrite the query so i can use it against an access table.

However, the query currently uses some things that access doesnt support, such as

SUBSTR
RTRIM
LENGTH

Anyone know the access alternatives??

Thanks

 

[fmm]

for LENGTH use len()

for SUBSTR use mid()

for RTRIM use trim()