ENCODE & DECODE

[shaun thornburgh]

Hi,

I have a table where users upload various data items via a web site. Some 
fields in the table are named DATA_ENC... to denote that the data should be 
encrypted uusing the encode function. This all works fine, however when I 
come to selecting the data from the table I would like to be able to select 
all the data and decrypt any fields as required. Is this possible with one 
query, or do I have to select every data item then decrypt it then present 
the data?

Thanks for your help