OMG- Tinkered with this and have it pulling where defined variable indicates a social security number.

Basically replacing the data string with '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]'

I working on another change to find all tables,...

Love this!!! :w00t:

Could it be modified to search for patterns? Like trying to find Social Security Numbers as long as they were formatted

where pattern= 'xxx-xx-xxxx'

That would be...

DUDE!!!!!!

YOU SO ROCK!!!!

Slight mod and all is Kewliossssss

select

cast(field as nvarchar(max))

from table

where sequence=value

Thank you very much.

Thanks!! I will try and let you know.

The ????'s are actually squares in the db, but I had to save txt file so that when I copied into this, it would not show Kanji.

Has anyone run into...