Would this query help determine if any extraneous characters present? SELECT * FROM MyTable WHERE LENGTH(resourceType) <> 3 AND resourceType LIKE 'PSM' ;
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users