How do I re-write my query so that it will decode the masked files.

[petejk]

I have select statement that is pulling up 'masked' password fields.
How do I re-write my query so that it will decode these masked fields.

Thanks

 

[[MVP] S.Clark]

I'm not sure if top secret's like these should be given across these
internets...
but, there used to be a little trick involving a UNION query. I won't get
anymore specific than that.

 

[petejk]

This is what I did to view it.

I wrote a ultra basic app in C# and ran a SELECT against the table I
wanted.
All 'password' flagged fields came back as plain text.

Now all the world has an alternative for this type of situation.