i know that I can trim a field using “Select… order by trim(myField)”. In this way all instances of myField show up trimmed.
But what about using trim to actually remove for ever the trailing spaces of records so that all records get really trimmed?
I would like, if possible, to avoid loading all the records in a listbox and update the database-fields feeding them the trimmed listbox.cell(i,0) / listbox.cell(i,1) etc.
Therefore, is there a SQLlite expression to to it?
Update … set myField = trim(myField)
Ah! So easy and strightforwad that is seems almost unbelievable. Thanks.