LEFT OUTER JOIN [INVENTTRANS] ON #TEMP.VOUCHERPHYSICAL=[INVENTTRANS].VOUCHERPHYSICAL WHERE [INVENTTRANS].ITEMID = #Temp.INVENTDIMID
This provides me nearly the result I am looking for. About 1/4th of the desired results are eliminated because
INVENTDIMID has a suffix appended to it in certain cases.
What is the proper syntax to succeed in a like clause similar to this intent.
WHERE '[INVENTTRANS].ITEMID%' like #Temp.INVENTDIMID
Alternatively, if there is no short hand way to do this, what is the most effective long handed way about it.