I have a database set up in OpenOffice with only one table called "biblio" with over 5000 records.
Most of the fields have many leading blank spaces. From what I've read, the Update statement listed below should work to clear Leading spaces in the "Title" field for ALL the records in the "biblio" table. (using Tools/SQL from the OpenOffice menu)
I've used the OpenOffice Base Query tool to generate a SELECT statement to ensure the table & field names are spelled correctly.
When I Execute the Update, it returns "function sequence error"
I'm a complete novice at this - I'm guessing I'm missing selection criteria, or some way to loop through all the records, or something else pretty simple.
Thanks for any clues . . .
UPDATE "biblio" SET "Title" = TRIM(LEADING FROM "Title")
(also tried putting a space in the statement)
UPDATE "biblio" SET "Title" = TRIM(LEADING ' ' FROM "Title")
UPDATE "biblio" SET "Title" = TRIM(BOTH FROM "Title")