> I tried the following
> "SELECT * FROM INSCOMPANY ORDER BY InsCode"
> and got an error message saying that InsCode field/column not found???

Depends on how the field was created.

SELECT * FROM INSCOMPANY
ORDER BY "InsCode"