Archives of the TeradataForum

Message Posted: Thu, 17 Jun 2004 @ 09:30:20 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

On Wed, 16 Jun 2004 21:13:34 +0530, Pandey, Vivek wrote:

Hi,

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.

www.teradataforum.com/teradata/20031203_102414.htm

You could modify it to be a full-blown ISNUMERIC function.

-97.67e+3.14

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>