Is it possible to copy data from a character field into a numeric field? [closed]
In LO Base, I would like to copy data (all numbers) from a VARCHAR field, to a NUMERIC field. I have try the command,
UPDATE "MyDatabase" SET "MY_NUMERIC" = CONVERT ("MY_VARCHAR", SQL_NUMERIC)
but it doesn't work. Any counsels.