https://learn.microsoft.com/en-us/sq...l-server-ver16





SELECT * FROM WareHouse.INV_Kala p
JOIN (SELECT * FROM STRING_SPLIT (N'کرم چندمنظوره',N' '))x ON p.Kala_FarsiDesc LIKE N'%'+x.value+'%'