Hi there, i have two little questions. First one, is this valid syntax for a CASE WHEN?
CASE WHEN ( [field1] IS NOT NULL ) AND ( ( [field1] < 1 ) OR ( [field1] > 0 ) ) In special I mean "can I use AND, OR in CASE WHEN". ________________________________ Second question, I get really strange results when I try to compare time values. For example: Given is a table with a field [field1] data type 'time'. Now I make a compare in a trigger like this. [field1] < TIME(NEW.TimeStamp) But this is not working :( Thanks for your help Steffen Mangold _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
