How to check the column value is numeric or not

muralithirumalaisamy · New User Joined: 13 Jun 2005 Posts: 12 Location: chennai

Hi,

Can anybody help me to write a query to check the value of a particular table column is numeric or character.

Thanks
Murali

Prasanthhere · Active User Joined: 03 Aug 2005 Posts: 306

How about this link

www.db2portal.com/2006/03/returning-only-numeric-data.html

muralithirumalaisamy · New User Joined: 13 Jun 2005 Posts: 12 Location: chennai

Thanks a lot...

lenygold · New User Joined: 22 Oct 2008 Posts: 3 Location: baltimore

Have fun:

SELECT CODE_DESC, 'NUMERIC' AS DATA_TYPE
FROM SIDDE010.VCODES TB1
WHERE LCASE(CODE_DESC) = UCASE(CODE_DESC)
UNION ALL
SELECT CODE_DESC, 'NOT NUMERIC' DATA_TYPE
FROM SIDDE010.VCODES TB1
WHERE LCASE(CODE_DESC) <> UCASE(CODE_DESC);

CODE_DESC DATA_TYPE
---------+---------+---------+---------+---------+-----
1099 NUMERIC
601 NUMERIC
602 NUMERIC
.............................................................

COURT LOCATION NOT NUMERIC
COURT ORDER FREQUENCY NOT NUMERIC
COURT ORDER SUBTYPE NOT NUMERIC
COURT ORDER TYPE NOT NUMERIC
COURT ROOM NOT NUMERIC