Hi,
I have a customer report I want to generate. I have a field for each customer called "sequence" in which I put a number (although some customers will have this field blank)

Using the SQL ORDER BY statement, how can I get the report to sort by "sequence" first, then have those without this value afterwards?

When using "ORDER BY Sequence, Address" I get:

AAA -
BBB -
CCC -
FFF - 1
EEE - 2

But how do I get:

FFF - 1
EEE - 2
AAA -
BBB -
CCC -