sel regexp_substr('aa6588fhfhf','[[:digit:]]+') Ans:65

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 / santosh

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

Answer Posted / santosh

sel regexp_substr('aa6588fhfhf','[[:digit:]]+')
Ans:6588

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List the logical and conditional operators that are used with teradata along with their meanings?

938

Describe the between keyword in teradata?

979

What are the available primary index types in teradata.

968

What is multi insert?

983

Explain teradata architecture in detail with a diagram.

1044

In BTEQ, how are the session-mode parameters being set?

1086

Explain the parallel data extension in teradata?

1024

What is logical data model?

1136

What are the available primary index types?

1145

What is primary index and secondary index?

972

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

1093

Define views in teradata with syntax.

1021

What is basic teradata query language?

1029

What are the functions of a Parser?

1023

What is TPD?

1306