Re: select MAX(field-name)

} } Hi Informix'rs, } } when I run SELECT MAX(col1) from table-name } where col2 = something } It returns 1 row(s) retrieved and the output is null, however Aggregate functions always return 1 row even if no rows exist that match the where clause, this is what you are seeing. } select col1 from table-name } where col2 = something No rows match so the select tells you so } It returns No rows found.......!!! } } any idea's.... Again an aggregate will always return a single row. } } thanks...... }