Hi!

When I use that sort order with the built in SIGN UDF (FB 1.5.3 SS):

SELECT * FROM TABLE ORDER BY SIGN(FIELD_NAME), OTHER_FIELD_NAME

The order of the records is wrong, because that only ordered by the
OTHER_FIELD_NAME.

SELECT * FROM TABLE ORDER BY SIGN(FIELD_NAME) is works fine.

Why didn't work 2 clause together, when the first one is an UDF
function??

Thanks!