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
- 6607 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 |
Give a justifiable reason why Multi-load supports NUSI instead of USI.
can we join volatile table with general table an global temporary table with general table ?
What is teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Write a program to show the parser component used in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Define views in teradata with general syntax.
What are two examples of an OLTP environment?
What is a level of granularity of a fact table?
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?
How does indexing improve query performance?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Teradata 
