Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answers were Sorted based on User's Feedback



Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH..

Answer / 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

Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH..

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

Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH..

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

Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH..

Answer / parthi

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Teradata Interview Questions

how teradata fetches a row from primary index table?

1 Answers  


How to run the Teradata jobs in unix environment ???

4 Answers   IBM,


What is the use of fallback?

0 Answers  


What is a node in teradata?

0 Answers  


which option is used to restart the fastexport script ?

2 Answers   TCS,


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

0 Answers  


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

0 Answers  


How many macros we can create inside a macro

1 Answers   Wipro,


what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?

3 Answers   HCL,


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

0 Answers   Infosys, Wells Fargo,


What does Amp contain and what are all the operations that it performs?

0 Answers  


Explain about Skew Factor?

6 Answers   TCS,


Categories