James Kimble wrote:
> It's not blanks either because if I
> do:
>
> where name link "key1%"
>
> I only get rows prior to "key199".
James can you try this to check the names?
select ':' || name || ':' from PerfTest1
where length(name) != length(trim(name));
It should display any names that have leading or trailing spaces with a
colon on each end so the spaces become visible.
HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
