Your question is a bit confusing and I'm not sure this is what you really want, however I think that LIKE is what you're looking for:

SELECT SomeColumns

FROM TableA

LEFT JOIN TableB

ON A.DeviceType LIKE B.DeviceDetail + '%'