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
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
What is the purpose of using case expression in teradata?
How many tables can you join in v2r5?
What is the primary index in teradata?
Difference between stored procedure and macro?
How do you define Teradata?
What is meant by a Least Cost Plan?
What are the various indexes in teradata? Why are they preferred?
What are the functions of a Parser?
Explain BYNET.
What are the components used in smp and massively parallel processing (mpp) machines?
What is logical data model?
What is meant by a Channel Driver?
What is the difference between global temporary tables and volatile temporary tables?
Explain fastload in teradata?
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