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
8400 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 is the difference between teradata and oracle?

1006

While creating table my dba has fallback or no fallback in his ddl. What is that?

1157

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

974

Why is the case expression used in teradata?

1067

List out teradata data types?

998

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

968

How is MLOAD Client System restarted after execution?

1125

How do you see a ddl for an existing table?

1001

Can we collect statistics on table level?

1013

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

2160

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

932

Explain the teradata primary index mechanics in detail with a diagram.

959

What is the purpose of joins in teradata and what are the available join types?

1060

Explain amp in teradata?

1060

Highlight the limitations of TPUMP Utility.

1100