neophyte - 8:42 am on Sep 8, 2010 (gmt 0)

phranque, Demaestro and LifeinAsia

Thanks to you all for weighing in on my issue.

LifeinAsia -

I think that you're right about my client interface (Navicat 8) probably has some default sorting routine, but I couldn't find any documentation of same or how to disable it.

Demaestro and LifeinAsia -

Adding an an additional sort field - primary key - does seem the path of least resistance (at least for the time being, as doing this will lead to re-numbering headaches - on the sort field - when nav updates/alterations are needed). However, doing this has solved my initial mystery sorting problem.

Thanks to you all.