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
8611 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 real time and near real time data warehousing?

1159

Why managing the data is important?

1056

Describe primary index in teradata. And what are the available primary index types?

1040

What are the different design perspectives used in teradata?

1034

what is sysdba and sysdbc ? which has high priority ?

3882

Explain some differences between mpp and smp?

1157

How you will check the version of teradata?

1221

Explain the term 'tables' related to relational database management system?

1103

What is the difference between global temporary tables and volatile temporary tables?

1237

What is a node in teradata? Explain

1053

Comment whether bottleneck is an error or not.

1219

What is teradata and why it is used?

1180

Explain the advantages of partitioned primary index in a query?

1070

What is logical data model?

1260

What are the 5 phases in a multiload utility?

1087