Archives of the TeradataForum
Message Posted: Thu, 17 Jun 2004 @ 09:30:20 GMT
On Wed, 16 Jun 2004 21:13:34 +0530, Pandey, Vivek wrote:
If you are on v2r5.1 you could write an ISINTEGER UDF and then just use it in your SQL.
sel a from mytable where isinteger(a);
Or take mine; I posted it as an example When 5.1 was first released.
You could modify it to be a full-blown ISNUMERIC function.
where it supports signs, decimal points, exponential notation and signs and decimal points in the exponential notation, but the simple ISINTEGER version in the post would work for your case.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|