Hi Frnds this que is recently asked at IBM
there are two rows like aa6588fhfhf,gru282vbvv.
Question is howcan we retrive the first number from two
rows.
Can any one help

thanks in advance

Answer Posted / ashutosh gautam

Use DIGITS("aa6588fhfhf") in transform it will return only
digit as 6588.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Highlight all the modes that are present under Confidence Level.

629


What are the newly developed features of Teradata?

664


Explain and compare pros and cons of snow flake schemas?

698


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

1836


What are the available join types in teradata?

695






Explain BYNET.

684


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4005


What is the difference between union and union all in teradata?

713


Explain the advantages of partitioned primary index in a query?

675


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

736


What is the function of parser component in teradata?

703


What is meant by a dispatcher?

656


Explain vproc in teradata?

663


Discuss the advantages of using partitioned primary index in a query?

616


Syntax for case when statement?

694