Hi, select case when division_no is null then 'no division' else 'with division' end from employee;
Is the right syntax Regards -- Matteo Beccati http://www.phpadsnew.com http://phppgads.sourceforge.net ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
