Hi! You should know the meaning of next SQL statements : SELECT DECODE(field_name, '0', 'Sunday', '1', 'Monday', '2', 'Tuesday') FROM table_name
(This should mean : if field_name = '0', return 'Sunday', if field_name = '1', returns 'Monday', ...) I try to use this with mysql (in EasyPHP: Apache + MySQL + PHP on Win32), but mysql returns error at the third parameter. It expected to use the DECODE decryption function which needs only 2 parameters. How can I perform this trigger without using another table? Regards, __________________ Mahefa RANDIMBISOA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]