> > select ItemNo, IIF(IsNull(Seq),'**oops**',Seq) from myTable > order by ItemNo > > That's in MS Access. In Oracle, use the NVL function. To round it out, SQL Server does it like this: Select IsNull(Seq,'***oops***') as Seq from myTable sgd