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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / tdguy
Assuming the column to be char(2), we can use the following
sql to retrieve the numeric values.
SEL C1 FROM
(SEL C1,
CASE
WHEN SUBSTR(C1,1,1) IN
('1','2','3','4','5','6','7','8','9','0')
THEN 'N'
WHEN SUBSTR(C1,1,1) IN (' ')
THEN 'S'
END AS ONE,
CASE
WHEN SUBSTR(C1,2,1) IN
('1','2','3','4','5','6','7','8','9','0')
THEN 'N'
WHEN SUBSTR(C1,2,1) IN (' ')
THEN 'S'
END AS TWO FROM STUD2
) A
WHERE ((A.ONE='N' AND A.TWO='N')
OR
(A.ONE='N' AND A.TWO='S')
OR
(A.ONE='S' AND A.TWO='N'))
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / parthi
SELECT * FROM C1
WHERE TD_SYSFNLIB.TO_NUMBER(C1) IS NOT NULL;
Is This Answer Correct ? | 0 Yes | 0 No |
What is teradata? Also, list out some of the primary characteristics of teradata.
What is the difference between global temporary tables and volatile temporary tables?
Why does varchar occupy 2 extra bytes?
Comment whether bottleneck is an error or not.
how many modules are there in telecome domain?how to explain the architecture?
What is the meaning of Caching in Teradata?
How to select first n records in teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
What is FILLER command in Teradata?
Explain the advantages of partitioned primary index in a query?
how do you handle ET and UV errors ?
What happens when a node suffers a downfall?