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
- 8467 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 can we analyze the locks ?
Explain vproc in teradata?
How many types of joins are there in teradata?
What is meant by a Channel Driver?
What are the different softwares used with their functions in teradata?
What are tpump utility limitations?
What is meant by a Least Cost Plan?
Explain and compare pros and cons of snow flake schemas?
What are the string manipulation operators and functions associated with teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is the maximum number of dml can be coded in a multiload script?
What are the different table types supported by teradata?
Explain the parallel data extension in teradata?
What's the difference between timestamp (0) and timestamp (6)?
Explain amp in teradata?
