How to retrive the last word in the Sentence in Teradata ?
Hai... i am new to Teradata . my objective is to retrieve the last word in the sentence with out hard coding . i got the sql query in Oracle but don't know how to accomplish the same in Teradata Sql. i am posting the Oracle Sql systax for retrieving the last word in the sentence . SQL> SELECT SUBSTR(sentence_column, INSTR(sentence_column,' ',-1) + 1) FROM Text_table;
column : sentence_column, data type : varchar2(100) Eg data : 1 All information must be store in table as data values 2 All views that are theoretically updateable are also updateable by the system. 3 The integrity constraints should store in the system catalog or in the database.
O/P : values system database
I need it in Teradata Sql query , please kindly help me . Thanks in Advance .