I usually use something like trim(field) like 'pattern'. Eliminates the need for the wildcard at the end. I find I use the ~ operator more than 'like' though.
On 8/10/20 10:01 AM, Michael Nolan wrote: > The problem is your field is fixed length text, change it to > varchar(100) or text and it works without the wildcard at the end.
That assumes values don't get entered with spaces: