I am trying to grab the value of custom5 0000% and compare it to skipcount and then if it is a higher value write it to skipcount, but something is wrong with my syntax, can anyone help?
INSERT OR REPLACE INTO SONGS (skipcount) Values SELECT substr( custom5, 1, 4) FROM SONGS WHERE custom5 > '0000%' and skipcount < cast( substr( custom5, 1, 4) as int ); -- Thank You, Kristopher C. Roy _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users