On May 9, 2012, at 8:01 PM, Shorty wrote:

> So, now the question is how do I write a statment to filter out strings so 
> the max() only evaluates the numeric values?

SELECT max( cast( userID as integer ) ) AS highest_userID FROM maillist;

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to