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
- 6352 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is meant by a Virtual Disk?
What are the 5 phases in a multiload utility?
What is bteq utility in teradata?
What is smp and mpp platforms?
What is the use of having index on table?
Different phases of multiload?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is the meaning of Caching in Teradata?
How will you solve the problem that occurs during update?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What are the uses of client software involved in teradata?
What is the difference between global temporary tables and volatile temporary tables?
What are the main components of teradata system?
Can you fastexport a field, which is primary key by putting equality on that key?
