Hi, when my categories table is empty:
Why would the second statement still return null if the first statements returns 'null'? select typeof(max(id)) from categories -- returns 'null' select case max(id) when null then 1 end as NextID from categories Thanks for all help, Kai _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
