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.
If, as you seem to state, MY_VARCHAR contains just numbers or is NULL then
UPDATE "MyDatabase" SET "MY_NUMERIC" = "MY_VARCHAR"
Will work.
Than you it worked. I did in fact find some non numeric characters impeding the operation.
Now, I am trying to filter database data so as to be able to edit only those records with the lastname beginning with “smi” In Lotus Approach one could use a wildcard character such as * or ? to filter the data. It there some kind of wildcard or filter I can use to find this data? I have found also I cannot edit queries, is such always the case?
Wildcards - (I’ve given you this site before): click here
Queries are just result sets of tables. To edit is meaningless.
As it seems you are new to this forum, please do not ask a question in a comment which is different from the original question. If answered, the question is not researchable by others. If your original question has been answered satisfactorily, you should mark it as answered and if you have another different question ask it as a new one. I trust you have read the brief How to use the Ask site page. Also, learn to use the format tools.