InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comFri, 05 Sep 2008 10:31:47 GMT20http://www.teradata.com/teradataforum/Topic9945-9-1.aspxThanks for your replyMany ThanksVedamurthyTue, 04 Dec 2007 23:52:33 GMTvedamurthy GYhttp://www.teradata.com/teradataforum/Topic9945-9-1.aspxFirst it is finding the starting position of substring 'BETWEEN DATE' using index function then adding 13 to get the starting position of the first Date range , then reading 12 characters from there to get the DATE value.Same technique for the other column.Tue, 04 Dec 2007 10:06:54 GMTSomeshhttp://www.teradata.com/teradataforum/Topic9945-9-1.aspxHi folks,This code is used for finding the start and end date of the partition, constrainttext is a column in a DBC veiw table. let me know why should they added 13 and -37select substring ( constrainttext FROM index(constrainttext,'BETWEEN DATE') +13 FOR 12 ), substring ( constrainttext FROM index(constrainttext,'NO RANGE') -37 FOR 12 )from dbc.indexconstraintswhere databasename = 'travel'and tablename = 'branch_item'Result:returns the overall partition from and to dates'2003-08-03' '2005-12-31'ThanksVedamurthyTue, 04 Dec 2007 02:42:29 GMTvedamurthy GY