What conditional statements are available if PointBase Embedded?

PointBase 5.4 and later supports the use of a CASE expression in a SELECT statement. For example: SELECT Name, CASE WHEN Grade > 80 THEN 'Honors' WHEN Grade >= 50 THEN 'Pass' ELSE 'Fail' END FROM students; Also a WHEN clause is supported in the TRIGGER creation statement. CREATE TRIGGER trigger3 BEFORE UPDATE ON product_tbl REFERENCING NEW AS NEWROW FOR EACH ROW WHEN (NEWROW.purchase_cost <0) SIGNAL 'Products prices cannot be negative' The details for both can be found in the PointBase Embedded documentation.