查询另一张表中某字符出现次数 sql

select EmpName,(select COUNT(*) from HRLate where Name like '%' + t.EmpName  + '%') from BaseEmployee t