On 29 Sep 2010, at 2:42am, Hemant Shah wrote: > If I use "length(MD5Sum) != 32" I get nothing. > > If I use "length(MD5Sum) == 32" I gat all rows. The length of the column > should be 32.
So do a "SELECT length(MD5Sum)" and see how long they really are. And if they're all 33, figure out where the extra character is at the beginning or end, then work out what character the extra character is. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
