I partially agree with everyone on the auditing.

I actually do both. I want to be able to know who inserted the record as well as who last updated it...

That looks pretty much what I am looking for.

As has been said the design is incorrect. The actual tables are correct. I was just trying to get a...

That explains it.

Thanks,

Tom

Actually the 3rd filter I was using was:

%[PD].%

So all three were:

exec sp_reset_connection

%PD.%

%[PD].%

I think it has something to do with the [].

If I take the "[" out it works fine and...

I didn't know there was a return value for isnull.

In most of the samples on line that is not even mentioned. But I did see a few that talked...

That was it.

Not sure why I didn't see that.

Thanks,

Tom

I am running on SSMS 2012 version 11.0.3000.0.

They all look pretty good and solve my problem.

Thanks a lot.

Tom

Serg,

That also works for my ALL question.

Serg and twin.devil,

I was looking at both solutions as I am not sure which I will need until tomorrow.

They both help out...

Ok.

The same table and split function as above.

The following Insert statements.

INSERT CSVTest(Name, States) Values('Joe','CA,FL,HI')

INSERT CSVTest(Name, States) Values('Mark','FL,MI')

INSERT CSVTest(Name, States) Values('Greg','MI,AR,AL')

INSERT CSVTest(Name, States) Values('Mary','AL')

INSERT CSVTest(Name, States) Values('Frank','AL,AR,WI')

Select @stemp = 'AR,AL'

This should...

This gives me any row that has any of the states in the @stemp variable.

Can the query be changed to give back only rows that have ALL the states in...

I agree on the design. Unfortunately, this isn't my design and I am working with someone else's database.

Your solution works except that it will not filter out duplicates?

select @stemp...

So sp_executesql doesn't care what the parameters are - just that you have the same types in the same order as in the query.

So even if you use the same...

In your solution, was there a reason you changed the order of the WHEN clauses or does it matter.

It didn't seem to in my solution after I added the converts.

Thanks

That makes sense and works fine now.

Thanks