Thread: how to do a select * and decrypt a column at the same time?

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

On Tue, Aug 16, 2005 at 12:53:51 -0700, The One <i51359@yahoo.com> wrote:
> Hello,
>  
> I have a table with one encrypted column.
> How can I do a select statement such that it will select all columns from the table and at the same time will decrypt
ittoo?
 

You want to explicitly list all of the column names in the select list, except
for the encrypted column for which you should call the decryption function.

On Tue, 2005-08-16 at 14:53, The One wrote:
> Hello,
>  
> I have a table with one encrypted column.
> How can I do a select statement such that it will select all columns
> from the table and at the same time will decrypt it too?

A view should be able to do that...