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
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is meant by a Virtual Disk?
What is the use of stored procedures in teradata?
What is the use of teradata system software?
What is meant by a Least Cost Plan?
Highlight a few of the advantages that ETL tools have over Teradata.
What are the functions involved in shared information architecture?
Mention a few of the ETL tools that come under Teradata.
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What do you mean by caching in teradata?
What are the available primary index types?
What is bteq script in teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
Explain teradata architecture in detail with a diagram.
Difference between stored procedure and macro?