Re: [SQL] how to do a select * and decrypt a column at the same

2005-08-24 Thread Scott Marlowe
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... ---(en

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

2005-08-16 Thread Bruno Wolff III
On Tue, Aug 16, 2005 at 12:53:51 -0700, The One <[EMAIL PROTECTED]> 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 o

[SQL] how to do a select * and decrypt a column at the same time?

2005-08-16 Thread The One
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?__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection ar