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
- 6412 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 is referential constraints?how do you implement RI in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What are the updated features of teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
Which is more efficient group by or distinct to find duplicates?
What is the basic syntax for teradata select statement?
What do you mean by parsing?
wt r before journal& after journel.....in teradata
Mention a few of the ETL tools that come under Teradata.
How to copy 1 million records from one DB to another, Which is effective interms of performance?
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
What is spool space? Why do you get spool space errors?
Teradata 
