Answer / santosh

Hi Friends some addition to 'Chelvam' ans.

SELECT C1 FROM <TABLE_NAME> WHERE UPPER(C1) =
C1(CASESPECIFIC) AND LOWER(C1) = C1(CASESPECIFIC)

Answer / chelvam

select C1,
CASE WHEN ( C1( UPPERCASE) = C1(CS) ) THEN
'NUMERIC'
ELSE
'ALPHANUMERIC'
END as C11
from TableName;

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'))

Answer / parthi

SELECT * FROM C1
WHERE TD_SYSFNLIB.TO_NUMBER(C1) IS  NOT NULL;

How does hashing happens in teradata?

0 Answers  

---

what is the difference between filter and router transmissions

2 Answers  

---

Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  

---

What do you mean by tpt in teradata?

0 Answers  

---

Diff b/w v2r5 and v2r6 ?

3 Answers   TCS,

---

Explain the meaning of Amp?

0 Answers  

---

Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,

---

How do you verify a complicated sql?

0 Answers  

---

What's the syntax of sub string?

1 Answers  

---

How can bottlenecks be identified?

0 Answers  

---

How do you determine the number of sessions?

0 Answers  

---

What is bteq utility in teradata?

0 Answers  

---