convert char to number [message #683790] |
Mon, 22 February 2021 02:55 |
mape
Messages: 298 Registered: July 2006 Location: Slovakia
|
Senior Member |
|
|
Hello
I would like to ask how to make a select to convert char to number ?
I've got records like:
-90.900000000000
0.000000000000
-87.760000000000
133.350000000000
241.620000000000
I try to use any kind of to_number but not successfully.
Does anybody know how to do it right ??
Thanks
Regards
mape
[Updated on: Mon, 22 February 2021 03:07] Report message to a moderator
|
|
|
|
|
|
Re: convert char to number [message #683794 is a reply to message #683793] |
Mon, 22 February 2021 05:13 |
|
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
If you don't post the actual issue you can't have an accurate answer.
Just remove the "." which are, I bet, "chr(0)" before applying to_number.
|
|
|