• if you use function !!! write new fn_split_find and don't use cross apply .it's will be work more faste :-D)

    select * from @mytbl where fn_split_find(likestring,@param) >0