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
8259 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

How do you verify a complicated sql?

1012

What are the primary characteristics of the Teradata.

1058

What are the design features involved in teradata?

974

Explain teradata utilities?

981

how do you manage the production space. what are the proactive methods you can take ?

1881

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

988

What is called partitioned primary index (ppi)?

959

what are the day to day activities of teradata DBA ?

5756

What is meant by a Parsing Engine?

1129

How you will check the version of teradata?

1077

Steps to create a data model?

1061

why use references rather than pointers in the public api, particularly for arguments which are modified?

938

Explain teradata architecture?

1031

Why does varchar occupy 2 extra bytes?

1105

What is the syntax for case when statement?

1055