and this will bring back results 'music teacher', 'teacher music' etc. The issue is when I search for 'music teacher' or 'good music teacher' only one result is returned or none whereas I would like for 'music teacher' and 'teacher music' to be returned. Is there a TSQL function that allows me to split the keywords in the string and search so that for example 'very good music teacher' still brings the results?
select * from title where job LIKE %music%
From novice to tech pro — start learning today.