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
8260 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 the difference between fastload and multiload?

1290

How do you create tables? Exact syntax, and create profiles, users in teradata?

974

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2132

Highlight the need for Performance Tuning.

1028

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2094

Explain parsing engine in teradata?

1024

What are the functions involved in shared information architecture?

1016

Explain the new features of teradata?

991

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1092

Explain the parallel data extension in teradata?

1026

What is spool space?

1074

Describe the set operators in teradata.

952

Discuss the advantages of using partitioned primary index in a query?

906

Different phases of multiload?

936

Explain teradata utilities?

981