Interested to Buy Any Domain ? << Click Here >> for more details...
Frnds....
i have one doubt
we have the num like this +913757575......i want to remove
91 and i want lo load remaining data to the target table..
whinch function we can use in teradata?????
Plz let me know..
thanks in advance
- 2 Answers
- 6463 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tdguy
Substr function would be suitable for this requirement.
Even if the column type is integer, substr can be used.
Implicit casting takes place. But trim function should be
used to avoid leading spaces.
example: column name - phoneno - type integer
value: - 913757575
SEL SUBSTR(TRIM(PHONENO),3,7) FROM TABLE;
Above sql will give you the correct output.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / hanumanth
Hi we can use substr function in teradata
like
sel c1,substr(c1,4,13)from table.
like this we can load
| Is This Answer Correct ? | 3 Yes | 0 No |
What is logical data model?
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?
What is called partitioned primary index (ppi)?
List the logical and conditional operators that are used with teradata along with their meanings?
What is a sparse index?
When tpump is used instead of multiload?
Mention a few of the ETL tools that come under Teradata.
What's the difference between timestamp (0) and timestamp (6)?
What are the updated features of teradata?
How to Extract data from multiple legacy systems?
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
Explain the teradata primary index mechanics in detail with a diagram.
Teradata 
