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

What do you mean by teradata sql assistant?

606


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

2916


Describe the set operators in teradata.

591


Explain amp in teradata?

585


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

576






Highlight the points of differences between the database and user in Teradata.

605


Highlight a few of the advantages that ETL tools have over Teradata.

626


What are the different table types that are supported by teradata?

547


What is the difference between teradata and oracle?

566


What is meant by a Channel Driver?

658


In Teradata, how do we Generate Sequence?

618


What are differences between teradata and ansi session modes in teradata?

636


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

585


What is the purpose of joins in teradata?

550


Define views in teradata with syntax.

652