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

On Tue, Aug 16, 2005 at 12:53:51 -0700,
The One <i51359(at)yahoo(dot)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 it too?

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.