>> 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' ?
Sorry, typo. I was doing trim(name)....
>> 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);
0 rows so it's not spaces. Could be unprintable characters I suppose. I've
tried a lot of different things and I still get no matches. I can do a
where with "like" all day long but no "=". Frustrating.....
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
