I have this code
b.TransDate, b.TransType, b.SortCode, b.AccNum, b.TransDesc, b.Debit, b.Credit,
(ISNULL(b.Debit, 0) + ISNULL (b.Credit, 0)) as Amount,
ISNULL(r.OrthoID, 'Need ID') as OrthoID
LEFT JOIN EPSBankRef r on b.TransDesc = r.BankID
but I would only like to try a join on the first 20 characters of b.TransDesc and not the full string. I'm not sure how I would best do that.