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
- 6591 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
What are teradata utilities?
What are the newly developed features of Teradata?
What are the uses of client software involved in teradata?
What are the joins in teradata?
What does Amp contain and what are all the operations that it performs?
How to eliminate product joins in a teradata sql query?
how do you manage the production space. what are the proactive methods you can take ?
Steps to create a data model?
Describe primary index in teradata?
How to select first n records in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
How is the teradata different from oracle?
How many codd's rules are satisfied by teradata database?
What are the various indexes in teradata? Why are they preferred?
Why does varchar occupy 2 extra bytes?
