db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Danny Gallagher <DGallag...@pathfire.com>
Subject dash in a varchar column - effect on select statement
Date Tue, 06 Dec 2011 15:45:58 GMT
Not sure why it is behaving this way, column is just varchar.

SELECT * FROM TABLE WHERE NAME = 'LKFSASP'

The only row in the table contains a NAME = 'LKFS-ASP'

Those two values aren't equal, but the row is returned from the select.

What am I missing?

Thanks






Mime
View raw message