https://community.sap.com/t5/technology-q-a/tsql-query-sql-server-2012/qaa-p/13835015#M4865858 <P>Your question does not have anything to do with SQL Anywhere, so this is not the right place to ask it.</P> Sun, 02 Mar 2014 16:16:38 GMT Breck_Carter 2014-03-02T16:16:38Z https://community.sap.com/t5/technology-q-a/tsql-query-sql-server-2012/qaq-p/13835014 <P>i have table named "path" with a single column named "path file name" and it contains something like this below: 1. U:01.03.141878Box1819P3FarihaTanzir(Moniruzzaman)0103141(756).jpg 2.U:01.03.141876Box1807P3Arif(Mahfuz)151213Picture 96609.jpg 3.U:01.03.141130Box1781P3RakhiSwpna(Farah)0103141 (1486).jpg 4.U:01.03.141952Box1810P1Sufia(Jakia)010314Picture 25304.jpg</P> <P>i want to get the names within the first braces() like: 1.Moniruzzaman 2.Mahfuz 3.Farah 4.Jakia</P> <P>i have used combination of patindex(),charindex() and substring function with left and right but could not get the desired result ,plz help.</P> Sun, 02 Mar 2014 14:03:02 GMT https://community.sap.com/t5/technology-q-a/tsql-query-sql-server-2012/qaq-p/13835014 Former Member 2014-03-02T14:03:02Z https://community.sap.com/t5/technology-q-a/tsql-query-sql-server-2012/qaa-p/13835015#M4865858 <P>Your question does not have anything to do with SQL Anywhere, so this is not the right place to ask it.</P> Sun, 02 Mar 2014 16:16:38 GMT https://community.sap.com/t5/technology-q-a/tsql-query-sql-server-2012/qaa-p/13835015#M4865858 Breck_Carter 2014-03-02T16:16:38Z