Ask Your Question
1

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

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

Quarto Die gravatar image

updated 2020-08-10 22:30:35 +0100

Alex Kemp gravatar image

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-10 22:30:43.791929

1 Answer

Sort by » oldest newest most voted
1

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

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 +0100 )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 +0100 )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 +0100 )edit

Question Tools

1 follower

Stats

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

Seen: 54 times

Last updated: Aug 04 '16