Re: ENCODE & DECODE

[Jeff Smelser]

On Friday 04 February 2005 11:00 am, shaun thornburgh wrote:
> Apparently not!
>
> mysql> SELECT DECODE ( CSV_DATA_ENC_FORENAME, "test_password" ) FROM
> DATA_TABLE_PID_1_DESC_137;

Is it so hard to read directions?

select decode(csv_data_enc_forename) from DATA_TABLE_PID_1_DESC_137;

This assumes whatever is in that column, was encoded.

Jeff

Attachment: [application/pgp-signature]