Getting one row with SELECT

With Informix^®, you must use the system table with a condition on the table id:

SELECT user FROM systables WHERE tabid=1 

With SQL SERVER, you can omit the FROM clause to generate one row only:

SELECT user