English John wrote:
Anyone got any ideas why this should be so? The only way to get the expected answer is to say SELECT * FROM user_list WHERE link<>'', which seems a bit perverse to me...
As a workaround, I've used CHAR(0) instead of '' for this, and that works fine. I'd still like to know what's going on here, though... ---------------------------------------------------------------------- John English | mailto:[EMAIL PROTECTED] Senior Lecturer | http://www.it.bton.ac.uk/staff/je School of Computing & MIS | "Those who don't know their history University of Brighton | are condemned to relive it" (Santayana) ----------------------------------------------------------------------