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
6501 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

How you will check the version of teradata?

1168

What are default access rights in teradata? What explicit right can be given to a user?

1112

Explain the parallel data extension in teradata?

1098

What is spool space?

1159

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1080

Explain the teradata primary index mechanics in detail with a diagram.

978

Explain teradata architecture?

1094

What are the various indexes in teradata? How to use them?

1018

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

988

Explain PDE.

1083

What are the advantages of teradata?

1017

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1113

Explain and compare pros and cons of snow flake schemas?

1035

What is called partitioned primary index (ppi)?

1013

What is the difference between teradata and oracle?

1027