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
- 4 Answers
- 7045 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / santosh
Hi Friends some addition to 'Chelvam' ans.
SELECT C1 FROM <TABLE_NAME> WHERE UPPER(C1) =
C1(CASESPECIFIC) AND LOWER(C1) = C1(CASESPECIFIC)
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How do you define Teradata?
What are the uses of bynets in multi-node systems?
Can you fastexport a field, which is primary key by putting equality on that key?
What are teradata utilities?
what is object level locking ? where do appear this type of locking ?
What are the things to be considered while creating secondary index?
Explain the term 'columns' related to relational database management system?
What is partitioned primary index (ppi)?
What can be achieved by using the teradata rdbms?
What is the purpose of indexes?
Mention a few of the ETL tools that come under Teradata.
What is meant by a Highest Cost Plan?
What are the components used in smp and massively parallel processing (mpp) machines?
What are differences between teradata and ansi session modes in teradata?
What are the scenarios in which full table scans occurs?
