[EMAIL PROTECTED] wrote:
>
> Simple select and I cannot make it work:
>
> Select name from PerfTest1 where name = trim('key5000');
>
Since the string literal 'key5000' doesn't contain leading or trailing
spaces, there is nothing for the trim function to remove. The result of
the trim function will be the same as the argument.
Select name from PerfTest1 where name = 'key5000';
If this doesn't work then you don't have any columns that match that
string value. This is probably due to trailing (or possibly leading)
spaces in the values in the name column. You should try trimming those
values instead.
Select name from PerfTest1 where trim(name) = 'key5000';
> This works:
>
> Select name from PerfTest1 where name like '%key5000%';
>
That is because this query matches names that have trailing and/or
leading spaces.
HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
