[sqlite] Is there equivalent to MySQL IF() function?

[Tony Papadimitriou]

Hi all,

Is there any an equivalent function to the MySQL 
IF(condition,true_expr,false_expr) function?

For example, SELECT AGE,IF(AGE < 3,"BABY",IF(AGE < 18,"CHILD","ADULT"));

If not, please add to wish list :)

TIA 

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