ORDER BY question

[Anon]

I'm doing a select on an integer field that may have null values.

SELECT * FROM some_table ORDER BY integer_field

When ORDER BY the integer field I get this:

null,
null,
null,
1,
2,
3,
4,
5

But what I want is this

1,
2,
3,
4,
5,
null,
null,
null

How can I do this?

[tomhath]

Try something like this (use whatever the maximum value is for the field):

select * from some_table
order by isnull(integer_field, 2147483647)