lookup based on wildcard

[tndl]

works perfectly and efficient! Thanks

[Ksharp]

Try LEFT JOIN instead of inner join.

[Patrick]

That won't resolve the multiple matches issue but just ensure that also non-matching jobs get returned to the result set.