It was set by ENCRYPTBYKEY...

Yes I stored it as a VARBINARY...

Here is how I set it up:

OPEN SYMMETRIC KEY Key_01

DECRYPTION BY CERTIFICATE DatabaseA01

UPDATE dbo.TableA

SET SSN = ENCRYPTBYKEY(KEY_GUID('Key_01'), SSN)

CLOSE SYMMETRIC KEY...

Yeah you are correct...

As I was going through it and thinking about it, I was like Why am I putting that information twice? That information is going to be in...

Thank you so much...That worked to perfection!

Again I thank you for your response!

This all was getting put into a temp table so when I modified the INSERT INTO my temp table to add the ROW_NUMBER()...

I just tried the above UPDATE statement...

But got the error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, so on or when...

Thank you...That is exactly how I need it to look...

However Im not very familiar with the ROW NUMBER (), OVER PARTITION BY statement and how would I use that in...

Thank you very much for your help on this query! I really do appreciate it!

How would you account for spaces in the last name?

Oh ok...didnt know that!

Thanks

@roryp 96873

So do I use NOT LIKE instead of LIKE since Im trying to find those with special characters?

So if Im looking for those that do have a number or some other character in it, do I need to put NOT LIKE instead of LIKE?

Thank you for your response!

Here is what it would look like when I try to INSERT INTO my Columns table

sp_MSForEachDB 'INSERT INTO DWMeta.dbo.DWColumns

( TableID,

ColumnName ,

DataType ,

IsPrimaryKey,

BusinessDescription,

UserAdded ,

DateAdded ,

UserEdited ,

DateEdited ,

Active

)

SELECT db_id(''?''), -- Would it...

That is what I did when I said it didnt work for me...I just changed the columns for what the Columns table used and used ? information_schema.columns

it threw me that...

Im sorry I think I confused you...

The script there is for INSERTING INTO my Tables table...I have already accomplished that...

Now Im trying to INSERT INTO my Columns table...