Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8612 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 many sessions of MAX is PE capable of handling at a particular time?
What's the difference between timestamp (0) and timestamp (6)?
Explain fallback in teradata?
Explain the term 'columns' related to relational database management system?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is database exceptions in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Describe the set operators in teradata.
In BTEQ, how are the session-mode parameters being set?
What interface is used to connect to windows based applications?
Highlight the advantages of PPI(Partition Primary Index).
What is the meaning of Caching in Teradata?
What are the functions of a Parser?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Highlight the points of differences between the database and user in Teradata.
