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

for LENGTH use len()

for SUBSTR use mid()

for RTRIM use trim()