Q&A for meta-discussion of the Stack Exchange family of Q&A websites
select id as [User Link] , aboutme from users cross apply string_split('landscaping,dentist,realestate',',') where aboutme like concat('%', value, '%')