itsquad
asked on
Can an Access join act like a wildcard search?
In the Query Builder window I have two tables, one has an indexed ItemNo field and in the other table, their is also a ItemNo value in the "Handle Field", however it's in a string that has other values that will of course not exactly match the ItemNo value. So when I try to join them... no results.
It'd be cool if my join could look through the string for a match and produce the matched results.
I'm sure it's not possible via a join, however what would be a good method to do this?
Thanks, Kevin
It'd be cool if my join could look through the string for a match and produce the matched results.
I'm sure it's not possible via a join, however what would be a good method to do this?
Thanks, Kevin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
and if you want all values from Table1 and only the "fuzzy matches" from table 2 use a LEFT JOIN in the above syntax
ASKER
Niiiiice! Never considered that as an option in the SQL window! I always just looked at the line in the query builder and double clicked it there to select join type... Wish Access had that pre-programmed in there! Thanks guys!