How can I check if the value is numeric? I tried is numeric but it is returning an error that the function is not found.
Example:
select *isnumeric*("abc") // returns 0 or false
select *isnumeric*("123") // returns 1 or true
Asked
Active
Viewed 4,383 times
1
-
Do you consider a value like "1.2E3" to be numeric? – Mike Sherrill 'Cat Recall' Jan 25 '17 at 03:45
-
isnumeric() is supported, but only in ASE version 15.0.1 or later. – RobV Jan 26 '17 at 10:36
1 Answers
5
A reasonable method is to look for non-digits:
select (case when str like '%[^0-9]%' then 0 else 1 end)
This looks for strings of digits. You can extend it to support negative signs, decimal points, and exponential representation if those are needed.
Gordon Linoff
- 1,242,037
- 58
- 646
- 786