Thank you capn.hector and anthony.green,

I didn't think it would be so easy. I thought there would be some kind of logic that would much more complicated... Sorry, I feel...

Sure, when can you start?

They started cleanup yesterday. As of this morning, there were less than 2500 records remaining... I think by the end of the week, they should be...

Thank you Everyone,

The REPLACE worked; however, after running the query, I found thousands records with all kinds of non-numeric values. That's is a lot of REPLACE(REPLACE(REPLACE...

So, I turned it back...

I'm going to start a conversation with the third party to see if they have any advice as to what might be going on.

I do own a handful of...

You are correct, it is a third party tool. It was setup of normal compression and it has been that way for a while now.

I also have a Maintenance...

That's what I thought as well. But this was on a Sunday night and no one worked yesterday. I also spoke with the customer and he mentioned that everything was...

Tank you to everyone. The work the eeryone posted helped me figure out what I needed to do. Thanks again and I appreciate your postings. 😀

Thank you for the reply. Unfortunately the query doesn't like " > 1". It throughs Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '>'.

Thank you. That's a lot easier...!

I'm not doing anything on the backend (and sorry if I lead you to believe this). HR is requesting a report from me. I'm trying to mask the SSN...

Never mind. I used a variable plus RIGHT

EXAMPLE:

DECLARE @mask VARCHAR(30)

SET @mask = 'XXX-XX-'

SELECT

p.FIRST_NAME + ' ' + p.LAST_NAME,

(SELECT @mask...

I knew it so was simple. I was using distinct and that was throwing the whole thing off... I feel real dumb right now... Sorry for wasting your time. 🙁

The problem here is, I don't know the tables. I need to do a series of actions in the...

CDC is great, thank you for the advice.

I do have a question that my research has not yielded a valid response.

CDC captures each table that a...

This is the code that I used...

IF EXISTS (SELECT *

FROM

...