Yes - and I just tried using the UNC instead, and it worked! (someone suggested it). I wonder how I didn't think of this myself... But it works now,...

I must not be getting something - I understand that you can't access the variables unless you put them in as readonly - what do you do if you need...

Interestin! I never heard of that before. My boss will hear about it Monday...

Thanks!

I know what you mean by string patterns, but what is regex?

That is what I was suspecting, too... I guess I will have to do this in VB, process one line at a time.

Thanks you very much for your opinion!

Marius

Lynn,

It's not all the "distinct" records I need to return, it is all records with a duplicate SSN that I am interested in. I tried the query, and it returns...

Perry,

It looks like this is it!! It is working...

can you recommend a book/ website/ anything else I could use to learn the more complex TSQL from? I do...

I will try this out Monday and I will let you know how it works. Many thanks!!!

I can't publish real data here, for obvious reasons. I don't think multiple names makes the difference. This is what I am getting:

Duck ...

Well, here's the full code:

SELECT [daily].[dbo].[CIS_Acct_Name].[Short_Last_Name],

[daily].[dbo].[CIS_Acct_Name].[Short_First_Name],

[daily].[dbo].[CIS_Acct_Name].[Middle_Initial],

[daily].[dbo].[CIS_Acct_Name].[Tax_ID_Number]

FROM [daily].[dbo].[CIS_Acct_Name]

...

Same result, but not quite: I actually have the duplicates now, and I can just delete those. I think it should work, I will try it out Monday.

Many...

Same thing... I'm getting everything, duplicates and non-duplicates.

Thanks, but I am still getting the duplicates on all 3 fields. In your table, you put:

NSERT INTO Person

SELECT 'Donald', 'Duck', 'SSN-001'

UNION ALL

SELECT 'Donald', 'Duck', 'SSN-002'

UNION ALL

SELECT 'Mickey', 'Mouse',...

yes, that is exactly what I am looking for... someone trying to use 2 (or more) different SSN's...

Current:

LastName FirstName ...

That doesn't work - there are no duplicates in that table because of the "group".. well, I'm lost again...