I'm having issues using the # wildcard character in an Access query. Previously, I've had no issues whatsoever, but now I cannot get any results returned with one.
The search criteria
Like "*test*local" returns
but Like "###test*local" returns nothing.
This query used to work, but after moving the tables to a new database, it no longer functions. Am I missing something?