SQLite Help Required

[Pete]

Back to the original question, I now know why the SQL script deleted all my records bar one.  I finally realised that in my BaseStation.sqb, the entries for Aircraft Type were not in the Type field but actually in ICAOTypeCode!  As my Type field only had one entry, it's obvious why all my entries disappeared.  The SQL script worked perfectly, it was a case of garbage in garbage out/ operator error!  Thanks all for your help.  Pete

[Anmer]

Thanks for sharing your findings.  It helps others to get updates like this.