Search pattern % doesnt work in access

Question

In the table trans I have two such values t_bar and t_pro, and I want to find such values in the table. that start with "t_" So I`m using such query:

select trim(col)
from trans
where trim(col) like "t_%";

No rows are returned. However such query will return desired 2 rows:

select trim(col)
from trans
where trim(col) like "t_***";

What is wrong here? I need to use %, because the real situation more difficult.

Answer 1

To match any number of characters that start with t_ you should use,

select trim(col)
from trans
where trim(col) like "t_*"