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.

What is the use of stored procedures in teradata?

941

---

What is meant by a dispatcher?

955

---

How do you set the session mode parameters in bteq?

1032

---

What are the joins in teradata and how many types of joins are there in teradata?

960

---

What are the steps involved in the process flow of the sql statement through channel attached system?

1050

---

Comment whether bottleneck is an error or not.

1073

---

What are the commands to make a new table, change a table and remove a table in teradata?

1066

---

How is MLOAD Client System restarted after execution?

1056

---

How do you do backup and recovery in teradata?

960

---

Highlight the advantages of PPI(Partition Primary Index).

1004

---

What are the available primary index types in teradata.

973

---

Why are oltp database designs not generally a good idea for a data warehouse?

989

---

Differentiate primary key and partition key?

934

---

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?

1130

---

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

770

---