Order by on text and numeric fields

[#1]

I have a table with 3 columns 1st column contains only text, 2nd column contains only numbers and 3rd column contains text.

I want to sort this table first on column 1 then column 2 in the load script.

I can sort by either of them individually but the following code sorts only on column 1.

load

*

Resident

TABLE

order by Coln1, Coln2;

Thanks

[swuehl]

Can't reproduce it here. Could you upload a small sample that demonstrate your issue?