db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Vatter <thomas.vat...@network-inventory.de>
Subject like '%something'
Date Tue, 28 Feb 2006 10:51:56 GMT
this is working
    select col from table where lower(col) like '%something%'
this is not
    select col from table where lower(col) like '%something'
try it with value in database = XXXsomething
seems like derby auto generates trailing blanks

tom


Mime
View raw message