is numeric in SQL - TechRepublic
TechRepublic | Forums | Web Development
Web Development
General discussion
August 14, 2003 at 03:26 PM
#2317098
john_wills

is numeric in SQL

by john_wills . Updated 22 years, 10 months ago

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 discussion is locked

All Comments