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
- 8453 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / chelvam
select C1,
CASE WHEN ( C1( UPPERCASE) = C1(CS) ) THEN
'NUMERIC'
ELSE
'ALPHANUMERIC'
END as C11
from TableName;
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What do you mean by caching in teradata?
What is the purpose of using case expression in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Highlight all the modes that are present under Confidence Level.
Discuss the advantages of using partitioned primary index in a query?
What is the difference between fastload and multiload? Which one is faster?
How to find duplicates in a table?
Explain teradata architecture in detail with a diagram.
Different phases of multiload?
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
Describe the set operators in teradata.
What are the 5 phases in a multiload utility?
Explain and compare pros and cons of start schemas?
What is meant by a Parsing Engine?
what are the day to day activities of teradata DBA ?
