db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John English ...@brighton.ac.uk>
Subject Re: Difference between view and select statement
Date Fri, 17 Mar 2006 19:05:59 GMT
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:je@brighton.ac.uk
  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)

View raw message