[closed] tsql query sql server 2012

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.

mssql server

asked 02 Mar '14, 14:03

kanchan
15●1●1●1
accept rate: 0%

closed 02 Mar '14, 16:17

Breck Carter
32.5k●539●724●1050

Your question does not have anything to do with SQL Anywhere, so this is not the right place to ask it.

(02 Mar '14, 16:16) Breck Carter

flat view

The question has been closed for the following reason "Question is off-topic or not relevant" by Breck Carter 02 Mar '14, 16:17

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

mssql ×40
server ×37

question asked: 02 Mar '14, 14:03

question was seen: 1,438 times

last updated: 02 Mar '14, 16:17

SAP SQL Anywhere

[closed] tsql query sql server 2012

The question has been closed for the following reason "Question is off-topic or not relevant" by Breck Carter 02 Mar '14, 16:17

Follow this question

Related questions