Microsoft Office - Tips & Tricks

[app_engine]

Using Access for some quick & dirty stuff (normally prefer sql*loader to Oracle and do things there but there are some limitations at the current setup)...

Found out that Access (2003) does not like the operator % in sql but prefers *

i.e. if you want to write a query that goes like

SELECT *
FROM TABLE1
WHERE NAME LIKE 'JO%'

you need to write

SELECT *
FROM TABLE1
WHERE NAME LIKE 'JO*'

Interesting