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
- 6497 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
Explain some differences between mpp and smp?
What are the functions of a teradata dba?
Mention a few of the ETL tools that come under Teradata.
List out teradata data types?
What are the newly developed features of Teradata?
Explain vproc in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is meant by a Clique?
Why are oltp database designs not generally a good idea for a data warehouse?
Explain teradata vs. Redshift?
What do you mean by teradata intelliflex?
What are some commonly used bteq scripts?
Differentiate database data and data warehouse data?
What is smp and mpp platforms?
