"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
Answer Posted / gvk
select substr("pravalli nagireddy",instr("pravalli
nagireddy",' '),10)from <tablename>
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is difference between user and database in teradata?
How can you track login parameters of users in teradata?
What are the enhanced features in teradata v2r5 and v2r6?
What is stored procedure in teradata?
What is the primary index in teradata?
What is the difference between teradata and basic rdbms?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Explain the most common data types used in teradata?
Which is faster fastload or multiload?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What are some primary characteristics of teradata?
What are the functions of a Parser?
What are types of partition primary index (ppi) in teradata?
Why teradata is used?
What is teradata? What are some primary characteristics of teradata?