Hey Everyone!

Wondering if this is even possible. I have a table with 2 columns (WO# , SchedFinish) I am ordering by SchedFinish ASC. However some of the SchedFinish values are null. I would like them at to fall after the non-null values. Is this possible.

SELECT WO, SchedFinish FROM "work"
ORDER BY SchedFinish ASC

So this is basically what I have. Can this be modified to sort the null values to the end?

ORDER BY IsNull(SomeField, 'zzzzzzzzzzzzzzzzzz')

Also, you don't need to specify ASC in the sort, because that's the default. You need to put DESC to override the default, but ASC is assumed.

SELECT WO, SchedFinish FROM "work" ORDER BY NOT IsNull(SchedFinish) DESC, SchedFinish [ASC];