Fernando,

>First of all, thanks for replying!
No problem :)

>The "Select 1" syntax is accepted by all SQL engines?

That's a good question ... I would assume that at least most db servers support this, since you're only supplying a constant in the select list. There's nothing really special to it.

> Initially I thought using the "Select Top 1" syntax, but Informix doesn't accept it.

The TOP clause is AFAIK not an ANSI standard clause, so I wouldn't expect it to be running on all RDBMS.

> Using the "Select 1" syntax with an Informix table returned me a result cursor with only one column named "Exp" with all values of "1".

The expected result of a SELECT 1 FROM table WHERE id=99 is to return a recordset with one column containing "1". Is that what you get?

Armin