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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

While creating table my dba has fallback or no fallback in his ddl. What is that?

1155


What is meant by a Virtual Disk?

1111


What is the use of stored procedures in teradata?

985


What is the use of teradata system software?

1018


What is meant by a Least Cost Plan?

1049


Highlight a few of the advantages that ETL tools have over Teradata.

1068


What are the functions involved in shared information architecture?

1055


Mention a few of the ETL tools that come under Teradata.

1061


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1095


What do you mean by caching in teradata?

1035


What are the available primary index types?

1199


What is bteq script in teradata?

1134


What are the commands to make a new table, change a table and remove a table in teradata?

1110


Explain teradata architecture in detail with a diagram.

1092


Difference between stored procedure and macro?

1149