Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 07 Dec 2005 @ 16:16:26 GMT

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

Subj:   Re: Check Values is Numeric?
From:   Victor Sokovin

  If only alphabets are present, you can use UPPER and CASESPECIFIC functions and check.  

This works only for ASCII characters. Even within the Latin character set in Teradata one can find a dozen or so characters for which lower case would be the same as the upper case.

I think the simplest way to detect numeric values is to do string comparison. In Latin (and standard collation rules) the test string could be just 'A', for example. One might also think about filtering out special characters with lower ASCII values except decimal dots or commas.

The "standard" recommendation nowadays seems to be to go use a User Defined Function (UDF) but then again you don't give such an advice to somebody who posts a question like this one, do you? It's like driving past a hitchhiker and shouting: "Get a car!"



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023