>Thanks Sergey -
>
>If we remove the alltrim() and set exact does not come into play, how can we assure ourselves of an exact match? ANy ideas?
>
>Great input as always
>
Hi Larry,

You can change

ALLTRIM(b.TRANNUMBER) = ALLTRIM(m.trannumber) 
to 
b.TRANNUMBER = PADR(m.trannumber, LEN(b.TRANNUMBER ))

and 

ALLTRIM(PRO_SCHT.SPFLAG)="*" 
to 
PRO_SCHT.SPFLAG = PADR("*", LEN(PRO_SCHT.SPFLAG))

It's possible to simplify those conditions based on your tables layout.