SELECT * FROM C1 WHERE TD_SYSFNLIB.TO

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 / parthi

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

Answer Posted / parthi

SELECT * FROM C1
WHERE TD_SYSFNLIB.TO_NUMBER(C1) IS NOT NULL;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the main components of teradata system?

1191

How you will check the version of teradata?

1220

What is a sparse index?

1119

Comment whether bottleneck is an error or not.

1219

Difference between star and snowflake schemas?

1239

What is the meaning of Caching in Teradata?

1185

What is inner join and outer join?

1170

What is partitioned primary index (ppi)?

1086

What is teradata? What are some primary characteristics of teradata?

1026

What is real time and near real time data warehousing?

1159

What is upsert statement in teradata?

1190

What is smp and mpp platforms?

1033

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1207

Explain the new features of teradata?

1089

What are the joins in teradata?

1070