Returns the number of curves defining the compound curve.
SELECT TREAT( Shape AS ST_CompoundCurve ).ST_NumCurves() FROM SpatialShapes WHERE ShapeID = 17
SQL/MM (ISO/IEC 13249-3: 2006) 7.4.4