select C1, CASE WHEN ( C1( UPPERCASE) = C1(CS) ) THEN 'NUMERIC�

Hi frnds...can any one help me regarding this que..

We have column in a table name it as C1 WHICH CONTAIN
ALPHANUMERIC AND NUMERIC VALUES.

C1
2A
2B
2V
2H
1
2
3
4
5

i want to retrive numeric values like 1,2,3,4,5

How we can get

Plz let me know.Thanks in advance

Question Posted / chelvam

4 Answers
8398 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / chelvam

select C1,
CASE WHEN ( C1( UPPERCASE) = C1(CS) ) THEN
'NUMERIC'
ELSE
'ALPHANUMERIC'
END as C11
from TableName;

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is bteq utility in teradata?

952

What is the use of teradata system software?

1021

In Teradata, how do we Generate Sequence?

1029

How will you solve the problem that occurs during update?

1039

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1222

What are the functions involved in shared information architecture?

1059

What is meant by a node?

1035

What are the various reporting tools in the market?

1039

What is meant by a Parsing Engine?

1174

Explain teradata architecture in detail with a diagram.

1098

What are the updated features of teradata?

1033

What are the uses of client software involved in teradata?

970

What do you mean by ttu in teradata?

1021

What are the available primary index types?

1202

What are the different methods ot loading a dimension table? A fact table etc?

1018