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
- 6464 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Why do you get spool space errors? How do trouble-shoot them?
How do you define Teradata?
What is collect statistics?
what are the uses of fact table and dimension table in banking project?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Explain the new features of teradata?
How do you set the session mode parameters in bteq?
What is meant by a Least Cost Plan?
Can you connect multiload from ab initio?
What is the difference between union and union all in teradata?
How to select first n records in teradata?
Describe primary index in teradata. And what are the available primary index types?
What is difference between user and database in teradata?
What are the functions involved in shared information architecture?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
