Shorty <sho...@shortypen.com> wrote: > Next Question - if I use the statment: > SELECT max(userID) AS 'highest_userID' FROM maillist WHERE userID <> '' > > Would that produce the same results for both NULL numeric entries and empty > strings?
NULL compares smaller than any other value. So, unless all the values are NULL, max() won't pick it. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
