on 2014 Mar 02 2:03 PM
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
i want to get the names within the first braces() like: 1.Moniruzzaman 2.Mahfuz 3.Farah 4.Jakia
i have used combination of patindex(),charindex() and substring function with left and right but could not get the desired result ,plz help.
User | Count |
---|---|
69 | |
9 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.