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
- 6509 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 are the different methods ot loading a dimension table? A fact table etc?
What are the main components of teradata system?
What is the function of parser component in teradata?
What happens when a node suffers a downfall?
Explain the term 'row' related to relational database management system?
What is logical data model?
What is a node in teradata?
Highlight the differences between Primary Key and Primary Index.
Find 2 highest sal from each dept who have completed 5 year in org
What are the types of tables in Teradata
22 Answers Cap Gemini, Cognizant, Infosys,
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
Why FLOAD does not support multiset tables??
Teradata 
