I am currently using dbo.fnsplit function in my database and works well with most of my queries. However I was wondering how I could use this function with LIKE.
Currently I have the below query but keep getting column name doesn't exist:
select * from Calls p inner join
(select * from dbo.fnSplit('75441222', ';')) Names
on p.OriginationNumber LIKE '%' + Names.OriginationNumber + '%'
Could someone please kindly show me how I can use this function with like, your help is much appreciated