sel substr(address,index(address,' ')+1) from db.emp; will give

"pravalli nagireddy" record is there in address column but i
want display only 'nagireddy' from the main string what is
query for that pls tell me

Question Posted / yuvaevergreen

Answer Posted / yuvaevergreen

sel substr(address,index(address,' ')+1) from db.emp;
will give you the string after the first space in the string.

Is This Answer Correct ?

12 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Where is teradata rdbms used?

1045

what is object level locking ? where do appear this type of locking ?

3452

How do you see a ddl for an existing table?

971

What is the use of having index on table?

962

How do you create tables? Exact syntax, and create profiles, users in teradata?

982

Define views in teradata with general syntax.

991

What interface is used to connect to windows based applications?

1048

What are the available join types in teradata?

1021

Describe the set operators in teradata.

960

What is teradata? Also, list out some of the primary characteristics of teradata.

993

What are some commonly used bteq scripts?

948

What is bteq utility in teradata?

923

What are the different softwares used with their functions in teradata?

972

How to run a query in teradata?

1016

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

921