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

Reply via email to