Do I have problem with some hidden characters in MS Access?

user_15200561 0
Viewed 40

I use data from MS Excel further in MS Access where I try to create several Queries. My Table contains the following numbers:

Table:
"111_1"
"222_2"
"123_3"

So, if I've built those query, I always receive not correct results: Query:

like "###_#"  | 0 Results
not like "###_#" | 3 Results

Why do I experience this kind of behavior? How can I avoid it? It seems like my inputs contains some hidden characters

Thank you

ms-access sql
1 Answers

The octothorpe designates a digit, so try with:

"###?#"

or:

"###_#"
user_35272970
Related