[thelist] SQL Order By Clause

Scott Dexter sgd at ti3.com
Fri Jul 27 10:19:02 CDT 2001


> 
>    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




More information about the thelist mailing list