DDA2323
GOLDE434
VDA-10345
.
.
.

from TXN_COUNT c join
     tb_acct a
     on c.acct_num like '%[^0-9]' + cast(a.acct_num as varchar(255))

from TXN_COUNT c join
     tb_acct a
     on c.acct_num like '%[^0-9]' + cast(a.acct_num as varchar(255)) OR
        c.acct_num = cast(a.acct_num as varchar(255)