I think he chose to make it an udf, so he could reuse the logic.

Yeah. Technically he could use xml to dynamically parse his string and directly relate it to his table.

DECLARE @x XML

SET @x = '<i>' + REPLACE( @filter, '|', '</i><i>') + '</i>'

SELECT...

I would also like to point out this method can get really messy in a text file, especially with a lot of columns. I would recommend you put the...

No problem. Glad I could help.

Also make sure you query results option is set to tab delimited. It makes the results much easier to read.

For best results you should use Excel or another storage medium like Word, as Kenneth stated. But this can be done by doing the following. What you can...

When you create your stored procedure you have to use the following SET options:

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

You have to alter your stored procedure or drop and recreate it. ...

Good deal. I am glad everthing worked out and thanks for the feedback.

Can you display the entire error message?

Yes, I created this generically without knowing your data. You should...

I am new to this XML query stuff so please forgive the question. I have tried to get your function to complile, but I keep getting errors about an alias...

The first thing we are doing is adding tags to all the values in the delimited string. E.g.

declare @filter varchar(25)

set @filter = 'test|test2'

DECLARE @x XML

SET @x = '<i>' +...

Well your options are to parse the string directly to an inner join or to create a udf that returns a table, that you will inner join.

DECLARE @x XML

SET @x...

I agree with Jack. The variables should be handled through the app. Additionally, in the try catch you are declaring a transaction; however, none of the code in...

For the EXCEPT keyword, I personally prefer to see ANSI join syntax in place of EXCEPT/INTERSECT. I think these 2 new keywords are more fitting for comparing multi-column result sets...