Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Alex Bernaards — — source: Usenet: comp.databases.informix
Hi,
For character to numeric:
table1.abc +0 = table2.123
And the other way:
table1.123 || " " = table2.abc
Alex
dario wrote:
>I would like to make some math operations with char entity
>(in database).
>The entity is all numbers but it is defined like char when
>create table was made.>Is it possible to make some kind of chat to num conversion
>inside sql query without altering table?
>
>Thanks
>Dario Primorac
>
>
>
>
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.