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

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

Question Posted / ashutosh gautam

5 Answers
9213 Views
IBM, I also Faced
E-Mail Answers

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 are the various indexes in teradata? How to use them? Why are they preferred?

1046

Did you write stored procedures in teradata?

1113

Explain vproc in teradata?

982

Explain the most common data types used in teradata?

1043

What are the different methods ot loading a dimension table? A fact table etc?

1018

What is difference between user and database in teradata?

1055

What are different table types used in teradata?

1024

What are the various indexes in teradata? Why are they preferred?

991

How is MLOAD Client System restarted after execution?

1123

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

1089

How will you solve the problem that occurs during update?

1037

What is the difference between teradata and oracle?

1005

What is inner join and outer join?

1092

Can you connect multiload from ab initio?

1199

Explain parsing engine in teradata?

1070