Man!, where are my posts going?........what the fk is going on!, lol......I posted here 20 minutes ago, now it's gone.

I got a result of sorts. I managed to work out the command to sort my sqlite contents either by ID or station....great!, but that only sorts the output on screen, it doesn't sort the contents physically and so, when viewed in the app on my phone, the list still has a clump of new stations at the bottom - I guess there is something wrong with the file itself.

The command, as stated by rinigus, was as follows;

SELECT * FROM stations ORDER BY STATION ASC; (I then read that ASC is set by default, so I can omit that in future).

(let's see if this post stays put!).......