Search results

Hi Guys, new here, thanks for any help offered. I'm self taught with Access so have limited knowledge and have hit an issue I can't find an answer to. If I use Like "*" in the criteria for a ShortText field, I get the results I expect. However if I use the following SQL I get no results...