The Underscore '_' works like an AND, doesn't it?
When searching for any of
test_12 , 12_test , 12 AND test , test AND 12
I get the same hit.
But why is there a problem with the wildcard?
mytest* AND abc_IN_CRM_C --> finds results!
abc_IN_CRM_C_mytest* --> no results!
abc_IN_CRM_C AND mytest* --> results ?!
What am I doing wrong?