Hi we can use substr function in teradata like sel c1,substr(c1,4,13)

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

Question Posted / hanumanth

2 Answers
6465 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

Please Help Members By Posting Answers For Below Questions

What is meant by a Least Cost Plan?

1055

Explain teradata utilities. What is multiload, fast load, tpump?

993

Mention a few of the ETL tools that come under Teradata.

1064

Explain teradata architecture?

1070

How does hashing happens in teradata?

1073

Explain the term 'tables' related to relational database management system?

1026

how many modules are there in telecome domain?how to explain the architecture?

2006

What are the available primary index types?

1202

What are the various reporting tools in the market?

1039

What do you mean by caching in teradata?

1040

What is inner join and outer join?

1093

Explain vproc in teradata?

984

What is the purpose of indexes?

1048

Highlight the limitations of TPUMP Utility.

1100

How is MLOAD Teradata Server restarted after execution?

1231