General discussion

Locked

is numeric in SQL

By john_wills ·
In Cobol one can enquire of an alphanumeric variable whether the content is numeric, viz.:
IF INPUT1 IS NUMERIC
THEN...
I want to be able to do the same in SQL, approximately thus:
SELECT IIF(IsNumeric(column1),Int(column1),0) AS X1...
What is the function I should use?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums