Hi
I have a database which has an entry "USE" in a table called airports
with column LocationID.
When I call
sqlite3 -line ~/Desktop/maps.db 'select * from airports where LocationID
like "USE%";'
I get correct result.
But when I call
sqlite3 -line ~/Desktop/maps.db 'select * from airports where
LocationID=="USE";'
I do not get any result.
When I call
sqlite3 -line ~/Desktop/maps.db 'select LocationID from airports;'
I do see that "USE" is in there among many other entries.
It only happens with "USE". Does not happen with "BOS" etc.
Thanks
Z
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
