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
8451 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 purpose of using case expression in teradata?

1017

How many tables can you join in v2r5?

1073

What is the primary index in teradata?

1203

Difference between stored procedure and macro?

1173

How do you define Teradata?

1037

What is meant by a Least Cost Plan?

1061

What are the various indexes in teradata? Why are they preferred?

1008

What are the functions of a Parser?

1113

Explain BYNET.

1005

What are the components used in smp and massively parallel processing (mpp) machines?

1057

What is logical data model?

1205

What is meant by a Channel Driver?

1249

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

1182

Explain fastload in teradata?

1108

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2867