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
- 7082 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
Explain the meaning of Amp?
How you will check the version of teradata?
What happens in a conflict? How do you handle that?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
How many tables can you join in v2r5?
What is teradata and why it is used?
Why does varchar occupy 2 extra bytes?
What is partitioned primary index (ppi)?
Explain the teradata primary index mechanics in detail with a diagram.
Difference between star and snowflake schemas?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Explain parsing engine in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the different functions performed in development phase?
What are the joins in teradata?
