Simple select and I cannot make it work:
Select name from PerfTest1 where name = trim('key5000');
This works:
Select name from PerfTest1 where name like '%key5000%';
I don't see any spaces in the text field. Do you ALWAYS have to use a LIKE
to get a match for TEXT strings? If not, what am I missing here?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
