Hello sql expert,
I am getting this error when executed below query:
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_Split", or the name is ambiguous.
How do I use the split function on my where clause? The split function name is: dbo.splitfuntion
Here is my query:
Declare @Column2value varchar(max)
Set @Column2value = 'ABC,CDE,FGH,IJK'
Select column1, column2, column3, column4
Where column2 = dbo.splitfuntion (@Column2value,',')
When funtion being call in the where clause, is that the best efficient way?