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
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 the difference between primary index and secondary index?.
Explain the term 'row' related to relational database management system?
What do you mean by ttu in teradata?
What are tpump utility limitations?
What is basic teradata query language?
What is the purpose of joins in teradata?
teradata support to automatically increase the character length or not?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
How do you determine the number of sessions?
What are the various reporting tools in the market?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Why do you get spool space errors? How do trouble-shoot them?