[EMAIL PROTECTED] wrote:
> Simple select and I cannot make it work:
>
> Select name from PerfTest1 where name = trim('key5000');
Since 'key5000' doesn't have any leading or trailing spaces, applying
trim() to it is pointless. Did you perhaps mean trim(name) = 'key5000' ?
> This works:
>
> Select name from PerfTest1 where name like '%key5000%';
This does suggest the value of "name" column has extraneous characters
(possibly but not necessarily whitespace) surrounding the text
'key5000'.
See if this statement returns any rows. Any whitespace should be clearly
visible:
select '!' || name || '!' from PerfTest1
where name != trim(name);
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
