Hi all,
Could anyone explain why the following LIKE statement:
Like "*adam*"
works well, on a single name field that includes first name and last name, returning results such as:
Adams Dane
Wright Adam
Thornber Adam
Adamson Geoff
But when I try to get user input (instead of using adam)...