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
- 8265 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
What is primary index and secondary index?
What is inner join and outer join?
Describe primary index in teradata?
How to identify ppi columns?
What is a node in teradata?
During the Display time, how is the sequence generated by Teradata?
What is spool space? Why do you get spool space errors?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
what are the day to day activities of teradata DBA ?
Explain fallback in teradata?
Can you connect multiload from ab initio?
Explain teradata utilities. What is multiload, fast load, tpump?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is the use of stored procedures in teradata?
What is node? How many nodes and amps used in your previous project?
