Hi,

> > > I need to come up with a statement that's as fast a #2 but also works

on

> > > most IB/FB engines.
> > > How should this statement look like ?
>
> > select * from table where pkcolumn = nonexistingvalue.
>
> The problem with this statement is that it forces me to know a bit too

much

> about the table :
> a column name and a non-existing value.
>
> Ideally, I'd need something more generic.
> Any other hint ?

No.

But why do you want to do this?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com