Just lately, I am having to change my SQL statements to retrieve data. Queries that use to be set to things such as WHERE some_int_field = other_int_field is now forcing me to do WHERE some_int_field LIKE other_int_field which is obviously slower. Any thoughts? Both fields are set as integer. Would be be causing this? I also outputed the length of the fields and they are correct so it doesn't appear to be a hidden space/character issue.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
