Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 text between characters

Author  Topic 

Brittney10
Posting Yak Master

154 Posts

Posted - 2014-10-04 : 12:53:45
How can i find a text between characters? For example (abc something here 123) I would just need to return abc something here 123 - removing the parenthesis.

Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-04 : 19:55:12
You can use the replace function to remove the parenthesis: SELECT REPLACE(REPLACE(column5, ')'), '(') FROM table1...

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -