Convert varchar to numeric in Informix
- by user302705
Hi All
I have problem while converting varchar type to Int type in Informix.
Actually I dont know if the value is really varchar or not which I want to convert to INT. Its a sandbox system.
As Example:
I am trying to run this kind of
Select telnumber from numbers n where Cast(n.telnumber AS INT) between 1234 and 9999
I got this error:
"Character to numeric conversion error"
If I run this query like this:
Select telnumber from numbers n where n.telnumber between '1234' and '9999'
it brings a resultset but not in the range that I defined.
130987
130710
130723
How can I convert telnumber to a numeric value and use it in "between" 1234 and 9999 range
Thanks in advance.
