Ask Your Question
1

Is it possible to copy data from a character field into a numeric field?

asked 2016-08-03 20:48:26 +0200

Quarto Die gravatar image

updated 2016-08-03 20:49:13 +0200

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2016-08-04 15:15:16 +0200

Ratslinger gravatar image

If, as you seem to state, MY_VARCHAR contains just numbers or is NULL then

UPDATE "MyDatabase" SET "MY_NUMERIC" = "MY_VARCHAR"

Will work.

edit flag offensive delete link more

Comments

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?

Quarto Die gravatar imageQuarto Die ( 2016-08-05 01:06:57 +0200 )edit

Wildcards - (I've given you this site before): click here

Queries are just result sets of tables. To edit is meaningless.

Ratslinger gravatar imageRatslinger ( 2016-08-05 01:23:19 +0200 )edit

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.

Ratslinger gravatar imageRatslinger ( 2016-08-05 03:20:25 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-08-03 20:48:26 +0200

Seen: 39 times

Last updated: Aug 04 '16